Re: OCI8 Stored procedure execution

Thanks, Thies, that did the trick. More general question: I want to find out which, if any, Oracle-specific SQL are supported by OCI8. I also need to figure out exactly which SQL are Oracle-specific. Is there a document/e-mail/publication summarizing this anywhere? thies@digicol.de wrote: > On Mon, Jun 12, 2000 at 08:28:52AM -0400, Fred Bulah wrote: > > > > Hello all, > > > > I am a new OCI8 user and am trying to execute an Oracle 8i stored > > procedure and get a return value back. > > > > The PHP4 code is: > > > > <?php > > print "<HTML><PRE>"; > > print "test 8: execute stored procedure<br>"; > > $conn = OCILogon("fredb","fmb22956"); > > $stmt = OCIParse( $conn, "execute mytest( :albumItemId );" ); > > OCIBindByName( $stmt, ':albumItemId', &$albumItemId, 10 ); > > OCIExecute( $stmt ); > > print "albumItemId=$albumItemId<br>"; > > OCIFreeStatement($stmt); > > OCILogOff($conn); > > print "</PRE></HTML>"; > > ?> > > > > Produces the following error: > > > > test 8: execute stored procedure > > > > Warning: OCIStmtExecute: ORA-00900: invalid SQL statement > > in /home/fredb/xanboo/htdocs/testoci8.htm on line 14 > > execute is not a known sql-command. (it's only known by > sqlplus) > > try > "begin mytest( :albumItemId ); end;" > instead. > tc > > > > albumItemId= > > > > > > The stored procedure definition is: > > > > /* mytest.sp: test stoed procedure */ > > create or replace procedure mytest( albumItemId out number ) > > is > > begin > > select albumitemseq.nextval into albumItemId from dual; > > end; > > / > > > > Executes without a problem from SQL/Plus. > > > > Can anyone help me locate the problem? > > Thanks. > > > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > > For additional commands, e-mail: php-db-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 > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net