|  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #10552 Exit() function never work when an Oracle error occures
Submitted: 2001-04-29 10:25 UTC Modified: 2001-04-29 11:10 UTC
From: azhdin at netcourrier dot com Assigned:
Status: Closed Package: OCI8 related
PHP Version: 4.0.4pl1 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 !
Your email address:
Solve the problem:
47 - 4 = ?
Subscribe to this entry?

 [2001-04-29 10:25 UTC] azhdin at netcourrier dot com
Here's my script where the problem occures.
You can see that there is a SQL statement error in $lvRequete because there a problem when an Oracle Error occures.
The first execution goes well, but since the second execution i've go the waiting cursor on my web page and the PHP module still running.

function MySQLStatement() 
	global $conn_id;

	$conn_id = OCILogon("myname", "mypass", "ORACLE");

	if ($conn_id == false)
		echo 'OWS-20004 : Oracle error. Unable to connect to destination !';
	$lvRequete = "*Select sysdate from dual";
	if ($SQLStatement = OCIParse($conn_id,$lvRequete))
		if (OCIExecute($SQLStatement)==0)
			echo 'OWS-20005 : Oracle error. SQL Syntax error !';
		echo 'OWS-20006 : Oracle error. Parse SQL error Level 0 !';
	if(OCIFetch($SQLStatement) != 0)
		$lvColumnName = OCIResult($SQLStatement,1);
		return $lvColumnName;
		return "Fetch Error";

$MyValue = MySQLStatement();
echo $MyValue;


Add a Patch

Pull Requests

Add a Pull Request


AllCommentsChangesGit/SVN commitsRelated reports
 [2001-04-29 11:10 UTC]
Should be fixed in latest CVS and possibly 4.0.5 which is due out tomorrow. Please re-open this bug report if neither of these versions fixes the problem
PHP Copyright © 2001-2023 The PHP Group
All rights reserved.
Last updated: Sat Apr 01 08:03:37 2023 UTC