RE: [PHP] Running ORACLE PL/SQL !

Hi Catalin. If my memory serves me correct, the SQLPLUS utility is for Oracle alone, and is gifted with some extended SQL-functionality, which do not exist in the SQL-specifications. The parser may not see the PL/SQL-query as a valid SQL-query for this reason, but this is not certan. However, You could try a SQL-query You know works on this script, and verify if it is a broken function in php. ;_) Best of luck, Henrik J. > ---------- > From: Catalin Ciocoiu[SMTP:catalin.ciocoiu@connex.ro] > Sent: den 7 september 2000 09:46 > To: php-general@lists.php.net > Subject: [PHP] Running ORACLE PL/SQL ! > > We have php4 with OCI library and we have tried to execute a PL/SQL > procedure. The code is like this: > $stmt=OCIParse($con,"execute myproc"); > OCIExecute($stmt,OCI_COMMIT_ON_SUCCESS); > > we have got the following error: > Warning: OCIStmtExecute: ORA-00900: invalid SQL statement in csicap.php > on line 48 > > The same query completes successfully when run from sqlplus. > Can somebody tell us why a PL/SQL procedure which runs OK from SQLPLUS > fails when run from PHP? > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >