Bug #10552 Updated: Exit() function never work when an Oracle error occures
| From: | andi@php.net | Date: | Sun, 29 Apr 2001 15:10:06 +0000 |
| Subject: | Bug #10552 Updated: Exit() function never work when an Oracle error occures | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-52915@lists.php.net to get a copy of this message | ||
ID: 10552
Updated by: andi
Reported By: azhdin@netcourrier.com
Old-Status: Open
Status: Closed
Bug Type: OCI8 related
PHP Version: 4.0.4pl1
Assigned To:
Comments:
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
Previous Comments:
---------------------------------------------------------------------------
[2001-04-29 10:25:29] azhdin@netcourrier.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;
?>
---------------------------------------------------------------------------
ATTENTION! Do NOT reply to this email!
To reply, use the web interface found at http://bugs.php.net/?id=10552&edit=2