php.net |  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
 [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.

<?php
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 !';
		exit;
	}
	$lvRequete = "*Select sysdate from dual";
	if ($SQLStatement = OCIParse($conn_id,$lvRequete))
	{
		if (OCIExecute($SQLStatement)==0)
		{
			OCILogOff($conn_id); 
			echo 'OWS-20005 : Oracle error. SQL Syntax error !';
			exit;
		}
		
	}
	else
	{
		echo 'OWS-20006 : Oracle error. Parse SQL error Level 0 !';
		exit;
	}
	if(OCIFetch($SQLStatement) != 0)
	{	
		$lvColumnName = OCIResult($SQLStatement,1);
		
		return $lvColumnName;
	}
	else
	{
		OCILogOff($conn_id);
		return "Fetch Error";
	}
	OCIFreeStatement($SQLStatement);
}

$MyValue = MySQLStatement();
echo $MyValue;
?>

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2001-04-29 11:10 UTC] andi@php.net
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-2024 The PHP Group
All rights reserved.
Last updated: Thu Dec 26 11:01:30 2024 UTC