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
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If this is not your bug, you can add a comment by following this link.
If this is your bug, but you forgot your password, you can retrieve your password here.
Password:
Status:
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-2024 The PHP Group
All rights reserved.
Last updated: Tue Apr 23 07:01:29 2024 UTC