[andi@zend.com: Fwd: [PHP-DB] OCI code broken after upgrading to PHP4R1]

----- Forwarded message from Andi Gutmans <andi@zend.com> ----- X-Sender: andi@127.0.0.1 X-Mailer: QUALCOMM Windows Eudora Pro Version 4.2.0.58 Date: Fri, 02 Jun 2000 11:55:27 +0300 To: thies@digicol.de From: Andi Gutmans <andi@zend.com> Subject: Fwd: [PHP-DB] OCI code broken after upgrading to PHP4R1 Did you see this Email on php-db? Andi >To: php-db@lists.php.net >From: kev <kevin.porter@fast.no> >Date: Fri, 02 Jun 2000 08:10:30 +0000 >Organization: FAST Web Media Ltd >Lines: 27 >X-Mailer: Mozilla 4.7 [en] (X11; I; Linux 2.2.12-20 i686) >X-Accept-Language: en >Subject: [PHP-DB] OCI code broken after upgrading to PHP4R1 > >Hi, > >I had to upgrade to PHP4R1, but now I get this error: kevin - returning of refcursors works for me. please see attached sql & script. tc > >Warning: OCIStmtExecute: ORA-03113: end-of-file on communication > channel >in... > >... from some code. The problem code appears to be this code: > > $sql = "begin kp_limit('$sql',:mycurs,$off,$nrows); end;"; >echo "\$sql = $sql<BR>\n"; > $stmt = OCIParse( $this->conn, $sql ); > OCIBindByName( $stmt, "mycurs", &$curs, -1, OCI_B_CURSOR ); > > OCIExecute( $stmt ); > OCIExecute( $curs ); > >which is accessing an Oracle stored procedure. It worked fine before the >upgrade. What changes do I need to make to get it working again? hopefully none. > > >thanks, > >- Kev > > > >-- >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 --- Andi Gutmans <andi@zend.com> http://www.zend.com/ ----- End forwarded message ----- -- 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

Attachment: [application/x-httpd-php] return_cursor.php
CREATE OR REPLACE PACKAGE info AS TYPE the_data IS REF CURSOR RETURN all_users%ROWTYPE; PROCEDURE output(return_data IN OUT the_data); END info; / CREATE OR REPLACE PACKAGE BODY info AS PROCEDURE output(return_data IN OUT the_data) IS BEGIN OPEN return_data FOR SELECT * FROM all_users; END output; END info; /