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

Thies, When I rebooted the machine this morning the errors went away - I had about 3 different builds of Apache/PHP running when I got the errors, I think it must have been getting confused somehow. I just have the one Apache executable running now, and it seems fine. I was panicking at the time though! I had upgraded to PHP4 1.0.0 from PHP4b3 to make some complex regex work, and then I couldn't use my lovely stored procedure (one of the most important pieces of code on the site) anymore! I was gutted. Oh well, all's well that ends well... thanks, - Kev thies@digicol.de wrote: > ----- 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 > > ------------------------------------------------------------------------ > > return_cursor.phpName: return_cursor.php > Type: application/x-httpd-php > > return_cursor.sqlName: return_cursor.sql > Type: Plain Text (text/plain)