|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
[2001-04-29 11:10 UTC] andi@php.net
|
|||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Mon Nov 03 04:00:01 2025 UTC |
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; ?>