Re: Running ORACLE PL/SQL !

Henrik Johansson wrote: > > 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 The parser didn't comme up with an error. > 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 > >