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:
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! Previous Comments: ------------------------------------------------------------------------ [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 ------------------------------------------------------------------------ [2007-10-09 08:07:43] markus dot knecht at psi dot ch I can reproduce the problem with your script. OS: Scientific Linux 4.x Server: Oracle9i 9.2.0.7.0 on different machine. Client: Oracle instant client 10.2 PHP: 5.2.4 compiled from source (--with-oci8=shared,$ORACLE_HOME ) With my previous version 5.1.6 the problem is NOT reproducable. ------------------------------------------------------------------------ [2007-08-31 21:19:55] iddekingej at lycos dot com Sorry "$l_cnt=0" is missing from the code. It should read: $l_res=oci_new_connect("<username>","<password>","<sid>"); oci_execute($l_st); $l_cnt=0; while(1){ $l_cnt++; $l_st=oci_parse($l_res,"select * from tblDocuments where id=$l_cnt "); oci_execute($l_st); $l_row=oci_fetch_row($l_st); oci_free_statement($l_st); echo $l_cnt,':';print_r($l_row); } ------------------------------------------------------------------------ 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
