|  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #20006 cannot use 2 database connections
Submitted: 2002-10-21 04:08 UTC Modified: 2003-12-12 07:56 UTC
Avg. Score:4.0 ± 0.8
Reproduced:3 of 3 (100.0%)
Same Version:0 (0.0%)
Same OS:2 (66.7%)
From: kezal at mail dot ru Assigned:
Status: Closed Package: OCI8 related
PHP Version: 4.3.3RC4-dev OS: Linux (RH)
Private report: No CVE-ID: None
View Add Comment Developer Edit
Anyone can comment on a bug. Have a simpler test case? Does it work for you on a different platform? Let us know!
Just going to say 'Me too!'? Don't clutter the database with that please !
Your email address:
Solve the problem:
45 - 41 = ?
Subscribe to this entry?

 [2002-10-21 04:08 UTC] kezal at mail dot ru
If you have created 2nd connection, you cannot use
1st connection. I think 2nd connection doesn't create its own Oracle cursor till first oraparse/exec executed

=== cut ===
	//1. Connect and exec OK.
	$conn_id1 = ociLogon("test","test123");
	$stmt1 = ociparse($conn_id1,"select count(*) from tbl_lang_");

	//2. Connect OK.
	$conn_id2 = ociLogon("book1","book123");

	//3. Exec fails!
	$stmt1 = ociparse($conn_id1,"select count(*) from tbl_lang_");
=== cut ===


Add a Patch

Pull Requests

Add a Pull Request


AllCommentsChangesGit/SVN commitsRelated reports
 [2002-10-21 05:29 UTC]
i could verfy that indeed there is a problem. please add a 
2nd tnsname for the same database and do 
$a = ocilogon(.., .., tns1); 
$b = ocilogon(.., .., tns2); 
to get two independent database connections. 
i really hope that i find some time to fix this soon!! 
 [2002-10-21 08:48 UTC]

once you're there, Thies, what could we about maintaining the connections over the database reloads as reported in several posts earlier.

I am, refering for the cases when, after restarting Oracle you'd need to necessarely restart apache. I tried to research on it and it seems to me that this is doable by controlling the connection via Zend handlers (or something like that) but I am still learning about Zend Engine, so couldn't fix that part yet.

Maxim Maletsky
 [2003-11-12 01:39 UTC] ash at deakin dot edu dot au
Just a question.. are the dates correct for this bug?  The version this bug applies to is 4.3.3RC4 which is reasonably current (well, last few months).

I did come across the problem, and was glad to know the cause of the problem.

 [2003-12-08 04:52 UTC] tony2001 at phpclub dot net
I can't reproduce this bug neither with HEAD, nor with PHP_4_3 branch.
does it still exist?
 [2003-12-12 07:56 UTC]
Thank you for your bug report. This issue has already been fixed
in the latest released version of PHP, which you can download at

seems to be fixed
PHP Copyright © 2001-2023 The PHP Group
All rights reserved.
Last updated: Sun Sep 24 15:01:24 2023 UTC