Re: Running ORACLE PL/SQL !

We have tried the following query: $stmt=OCIParse($con,"begin sss; end"); and we have got the following error: Warning: OCIStmtExecute: ORA-06550: line 1, column 15: PLS-00103: Encountered the symbol "END" when expecting one of the following: ; The symbol ";" was substituted for "END" to continue. in csicap.php on line 48 Thies Arntzen wrote: > > On Thu, Sep 07, 2000 at 10:46:05AM +0300, Catalin Ciocoiu wrote: > > 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"); > > $stmt=OCIParse($con,"begin myproc; end"); > > should work. "execute" and "exec" are handled (and expanded to > "begin" ... "end" by sqlplus) > > tc > > > 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 > > -- > > Thies C. Arntzen "One Big-Mac, Small Fries and a Coke!" > Digital Collections Phone +49 40 235350 Fax +49 40 23535180 > Hammerbrookstr. 93 20097 Hamburg / Germany