|  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #29524 Trying to connect to an oracle 9i Db, script hangs, same script on PHP4 works
Submitted: 2004-08-04 14:21 UTC Modified: 2004-08-21 01:00 UTC
Avg. Score:5.0 ± 0.0
Reproduced:1 of 1 (100.0%)
Same Version:1 (100.0%)
Same OS:1 (100.0%)
From: fadi at netways dot com Assigned: tony2001 (profile)
Status: No Feedback Package: OCI8 related
PHP Version: 5.0.0 OS: Windows 2000
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 — but make sure to vote on the bug!
Your email address:
Solve the problem:
35 - 17 = ?
Subscribe to this entry?

 [2004-08-04 14:21 UTC] fadi at netways dot com
PHP 5.0 (Release)
Windows 2000 server
IIS 6.0 (PHP runs as ISAPI module)
Oracle 9i Client Tools (Admin)
ORACLE_HOME correctly set as system variable

Oracle Databae 9i installed on a separate reachable server (i tested sqlplus).

IUSR_XXXX has correct permissions to C:\PHP and C:\Oracle\Ora92 directories.

IMPORTANT: Simply replacing PHP 5 with PHP 4.3.4 works

Reproduce code:
	$conn =	OCILogon('username', 'password', $dbConnString);
	if( $conn ) echo "Connected:" . OCIServerVersion( $conn );
	else {	
		echo "Not Connected";
	$query = "SELECT * FROM LoginBackOffice";
	$statement = OCIParse ($conn, $query);
	OCIExecute ($statement);
	while (OCIFetchInto ($statement, $row, OCI_ASSOC)) {
	    echo "<hr>";
	    print_r( $row );
	ocilogoff( $conn );

Expected result:
2 rows of data!!!!

Actual result:
Script hangs indefinitly


Add a Patch

Pull Requests

Add a Pull Request


AllCommentsChangesGit/SVN commitsRelated reports
 [2004-08-12 05:02 UTC] vincomaldini at hotmail dot com
I've had this SAME problem on two different machines with W2K spk4, Oracle and IIS.

It seems that any attempt to use OCILogon or oci_connect causes the script to hang indefinitely and not close the HTTP connection.
 [2004-08-13 17:41 UTC]
Please try using this CVS snapshot:
For Windows:

There were some thread safety related changes. Please, try a snapshot.
 [2004-08-21 01:00 UTC] php-bugs at lists dot php dot net
No feedback was provided for this bug for over a week, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Sun Apr 14 09:01:29 2024 UTC