#37055 [Opn]: lost link /multiple logns / free statment
| From: | ilya dot gruzinov at gmail dot com | Date: | Wed, 12 Apr 2006 12:59:41 +0000 |
| Subject: | #37055 [Opn]: lost link /multiple logns / free statment | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-95673@lists.php.net to get a copy of this message | ||
ID: 37055
User updated by: ilya dot gruzinov at gmail dot com
Reported By: ilya dot gruzinov at gmail dot com
Status: Open
Bug Type: OCI8 related
Operating System: Debian stable
PHP Version: 5.1.2
New Comment:
more correct example, with ociexecute
<?php
$db1 = oci_pconnect ("ilya", "ilya", "cc10");
$sth1 = OCIParse($db1, "select * from test");
OCIExecute($sth1);
$db2 = oci_pconnect ("ilya", "ilya", "cc10");
$sth2 = OCIParse($db2, "select * from test");
OCIExecute($sth2);
ocifreestatement($sth1);
ocifreestatement($sth2);
$sth3 = OCIParse($db2, "select * from test");
?>
PS: problem only with persistent connection and php 5.1.2, with 5.1.1 i
have not problem
Previous Comments:
------------------------------------------------------------------------
[2006-04-12 12:57:42] ilya dot gruzinov at gmail dot com
Description:
------------
I make 2 connections. After every connect i run query on new link.
Then i free statment from results and try run query for second
connections and get warning.
Reproduce code:
---------------
<?php
$db1 = oci_pconnect ("ilya", "ilya", "cc10");
$sth1 = OCIParse($db1, "select * from test");
$db2 = oci_pconnect ("ilya", "ilya", "cc10");
$sth2 = OCIParse($db2, "select * from test");
ocifreestatement($sth1);
ocifreestatement($sth2);
$sth3 = OCIParse($db2, "select * from test");
?>
Expected result:
----------------
_empty_
Actual result:
--------------
Warning: ociparse(): 3 is not a valid oci8 connection resource in
/home/shagren/public_html/oracle10/test2.php on line 12
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=37055&edit=1