This may be fixed in 4.0.5
<[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> From: [EMAIL PROTECTED]
> Operating system: Windows 2000
> PHP version: 4.0.4pl1
> PHP Bug Type: OCI8 related
> Bug description: Exit() function never work when an Oracle error occures
>
> 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;
> ?>
>
>
> --
> Edit Bug report at: http://bugs.php.net/?id=10552&edit=1
>
>
>
> --
> 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]
>
--
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]
