ID:               37055
 Updated by:       [EMAIL PROTECTED]
 Reported By:      ilya dot gruzinov at gmail dot com
-Status:           Open
+Status:           Closed
 Bug Type:         OCI8 related
 Operating System: Debian stable
 PHP Version:      5.1.2
 New Comment:

This bug has been fixed in CVS.

Snapshots of the sources are packaged every three hours; this change
will be in the next snapshot. You can grab the snapshot at
http://snaps.php.net/.
 
Thank you for the report, and for helping us make PHP better.




Previous Comments:
------------------------------------------------------------------------

[2006-04-12 12:59:41] ilya dot gruzinov at gmail dot com

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

------------------------------------------------------------------------

[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

Reply via email to