Description:
------------
Hello,
we built latest 5.2.2 on May 6, 2007 with Oracle 10 g R1 client on 
SuSE Linux 9.3 (x86-64)
platform.  We get this error now on large Oracle tables (> 90,000 rows).  

Fatal error: Allowed memory size of 16777216 bytes exhausted at
/usr/local/php-5.2.2/ext/oci8/oci8_interface.c:1428 (tried to allocate
24 bytes)

Bug 39640 says closed and fixed, but we get it for oci8, installed yesterday from latest snapshot.

Reproduce code:
---------------
php build info -

'./configure' '--prefix=/usr/local' '--with-apxs2=/usr/sbin/apxs2' '--with-oci8=/opt/oracle/product/10g1' '--with-mysql=/usr' '--with-zlib' '--enable-debug' '--enable-sigchild'

We dropped back to 4.4.7 and error is gone.

Statements that generated this error:

$cstring = "(DESCRIPTION=(ADDRESS=(PROTOCOL = TCP)(HOST = host.machine (PORT = 1521))(CONNECT_DATA =(SID =
DB)))";

$conn = @OCIlogon("$username","$password", $cstring);		

$stmt="select $select_fields from $table_name order by $sort_field $sort_direction";

$verify=ociparse($conn, $stmt);
ociexecute($verify) or die ("SQL execution has failed. Failed statement =$stmt");
$nrows = OCIFetchStatement($verify,$results);



Expected result:
----------------
A table of output.

Actual result:
--------------
Fatal error: Allowed memory size of 16777216 bytes exhausted at
/usr/local/php-5.2.2/ext/oci8/oci8_interface.c:1428 (tried to allocate
24 bytes)


I do not have any backtrace info recorded.

Any help would be appreciated.

Thanks,
Leslie Galloway
i65@ornl.gov