ID: 10552
Updated by: andi
Reported By: [EMAIL PROTECTED]
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] [EMAIL PROTECTED]
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
--
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
