ID: 42496 Comment by: martin at catalyst dot net dot nz Reported By: iddekingej at lycos dot com Status: Open Bug Type: OCI8 related Operating System: win 2000 PHP Version: 5.2.4 New Comment:
This Moodle bugreport is related: http://tracker.moodle.org/browse/MDL-11429 Note that under moodle (using AdoDB) we are seeing the problem as soon as the resultset contains at least one LOB. If the table has LOBs but the resultset is empty, no cursors are leaked. Previous Comments: ------------------------------------------------------------------------ [2007-11-08 23:38:57] martin at catalyst dot net dot nz These are the revisions as reported in phpinfo() for the versions I've tested: grep -r Revision oci8-1.*/oci8.c oci8-1.1.1/oci8.c: php_info_print_table_row(2, "Revision", "$Revision: 1.274 $"); oci8-1.2.3/oci8.c: php_info_print_table_row(2, "Revision", "$Revision: 1.269.2.16.2.29 $"); oci8-1.2.4/oci8.c: php_info_print_table_row(2, "Revision", "$Revision: 1.269.2.16.2.38 $"); oci8-1.3.0/oci8.c: php_info_print_table_row(2, "Revision", "$Revision: 1.269.2.16.2.38.4.1 $"); ------------------------------------------------------------------------ [2007-11-08 23:34:29] martin at catalyst dot net dot nz Narrowed down the problem to the OCI8 driver, which is versioned separately from PHP. After a bit of testing, the problem appeared in v1.2.4 of OCI8, which got included in PHP v5.2.3 OCI8 v1.2.3 does not exhibit the problem. vOCI8 1.3.0 Beta (as of today) still exhibits the problem. I've reported it on the bugtracker here http://pecl.php.net/bugs/bug.php?id=12407 linking back to this bug. The different versions of the OCI8 driver are downloadable from http://pecl.php.net/package/oci8 -- HTH! ------------------------------------------------------------------------ [2007-11-08 16:38:49] br at absb dot de We experience this bug to a further extend than described before: - Selecting 2 clobs in one query fails (SELECT c1, c2 FROM c_table) - Selecting the same clob twice in the same query fails (SELECT c1, c1 from c_table) - Selecting more than one row with a clob fails (SELECT c1 FROM c_table WHERE ROWNUM < 10) - Selecting one row with clob WORKS (SELECT c1 FROM c_table WHERE ROWNUM <= 1) ------------------------------------------------------------------------ [2007-10-31 17:52:39] natxo dot cabre at gmail dot com I can reproduce the problem as well. OS: RedHat 4 Enterprise ES Server: Oracle9i Enterprise Edition Release 9.2.0.7.0 Client: Oracle instant client 10.2 PHP: 5.2.2 compiled from source (--with-oci8=instantclient,$ORACLE_HOME ) ------------------------------------------------------------------------ [2007-10-10 06:14:24] markus dot knecht at psi dot ch Sorry, the build is --with-oci8=instantclient,$ORACLE_HOME ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/42496 -- Edit this bug report at http://bugs.php.net/?id=42496&edit=1
