php.net |  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
Votes:1
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
Have you experienced this issue?
Rate the importance of this bug to you:

 [2004-08-04 14:21 UTC] fadi at netways dot com
Description:
------------
Platform:
=========
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:
---------------
<?php
	$dbConnString = "(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST = myserver)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=mydb)))";
	$conn =	OCILogon('username', 'password', $dbConnString);
	if( $conn ) echo "Connected:" . OCIServerVersion( $conn );
	else {	
		echo "Not Connected";
		exit();
	}
	$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

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

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 9.2.0.1 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] tony2001@php.net
Please try using this CVS snapshot:

  http://snaps.php.net/php5-latest.tar.gz
 
For Windows:
 
  http://snaps.php.net/win32/php5-win32-latest.zip

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: Tue Apr 23 19:01:31 2024 UTC