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

Before this gets any further - it's *NOT* PHP4 1.0.0, it's PHP 4.0.0 - fairly big semantic difference :) Zeev On Fri, 2 Jun 2000, kev wrote: > 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) > > > -- Zeev Suraski <zeev@zend.com> http://www.zend.com/