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
View Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or if you reported this bug, you can edit this bug over here.
(description)
Block user comment
Status: Assign to:
Package:
Bug Type:
Summary:
From: azhdin at netcourrier dot com
New email:
PHP Version: OS:

 

 [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

Add a Patch

Pull Requests

Add a Pull Request

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-2023 The PHP Group
All rights reserved.
Last updated: Thu Feb 09 13:03:40 2023 UTC