#42496 [Com]: cursor is not closed when using 2 clobs in a select query
| From: | martin at catalyst dot net dot nz | Date: | Thu, 08 Nov 2007 23:34:30 +0000 |
| Subject: | #42496 [Com]: cursor is not closed when using 2 clobs in a select query | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-119373@lists.php.net to get a copy of this message | ||
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