[PHP] oracle 8i stored procedures + php access

[Robert Mena]

Hi, I have a delphi application that uses oracle as db
server with stored procedures (running ok).

I've been trying to make a php version of such
application with no luck so far.

I've created a user to access such thing and I keep
getting the following error

Warning: OCIStmtExecute: ORA-06550: line 3, column 3:
PLS-00905: object
SYSTEM.CAD013_PSQ_RSV is invalid ORA-06550: line 3,
column 3: PL/SQL:
Statement ignored in
/somewhere/test.php on line 20

Warning: OCIFetchInto: ORA-24338: statement handle not
executed in
/somewhere/test.php on line 31

If I try with user system the messages are diferent

Warning: OCIStmtExecute: ORA-06550: line 3, column 3:
PLS-00905: object SYSTEM.CAD013_PSQ_RSV is invalid
ORA-06550: line 3, column 3: PL/SQL:
Statement ignored in
/somewhere/test.php on line 20

Warning: OCIFetchInto: ORA-24338: statement handle not
executed in /somewhere/test.php on line 31

The script follows


 putenv("ORACLE_BASE=/u01/app/oracle") ;
 putenv("ORACLE_HOME=/u01/app/oracle/product/8.1.7");
 putenv("ORACLE_SID=oracle") ;

  $usernameOracle=dbuser;
  $passwordOracle=dbpassword;
  $hostOracle=dbhost;

 $tsA = time() ;
  $con =
OCIPLogon($usernameOracle,$passwordOracle,$hostOracle);
  $tsD = time() ;

$res = OCINewCursor($con);
$stm = OCIParse ( $con, "
BEGIN
  CAD013_PSQ_RSV(:pkey, :Option, :RES);
END;
");

$name = "foo";
$option = "0";

OCIBindByName ( $stm, ":pkey", $nome, -1);
OCIBindByName ( $stm, ":Option", $option, -1);
OCIBindByName ( $stm, ":RES", &$res, -1, OCI_B_CURSOR
);
@OCIExecute ( $stm );
OCIExecute ($res);

$arrError = OCIError($res);

if ($arrError['code'])
{
  echo
$arrError['code']."-".$arrError['message']."<br>";
  exit;
}

while (OCIFetchInto($res,&$data))

  var_dump($data);
}

OCIFreeCursor($stm);
OCIFreeStatement($res);

The stored procedure has one code bellow

IF (vmINT_QtdLines <= 0) THEN
        -- PHP
              raise_application_error(
              -20005,
              'NAME NOT FOUND'
            );
        -- DELPHI
--          DBMS_OUTPUT.PUT_LINE('NOTHING
FOUND:'||pkey);
--          RAISE Erro;
        END IF;

I am not quite sure where the problem is located.  Any
help (if directly related to oracle emails directly)
wl be appreciated.

Thanks.



__________________________________________________
Do You Yahoo!?
Send your FREE holiday greetings online!
http://greetings.yahoo.com

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]