ID: 25123
Comment by: guenter_doge at web dot de
Reported By: karel dot miarka at issa dot cz
Status: Open
Bug Type: OCI8 related
Operating System: Windows 2000
PHP Version: 4.3.3RC5-dev, 5.0.0b2-dev
New Comment:
Could not reproduce this with PHP 4.3.3 & IIS 5.0 & win 2k & Oracle
8.1.7
One guess: Disable tracing in Oracle ("Set Autotrace Off") and try
again.
Previous Comments:
------------------------------------------------------------------------
[2003-08-18 00:58:09] karel dot miarka at issa dot cz
Description:
------------
ocierror() function:
1) returns ORA-24315 illegal attribute type
after any error. For example ociexcute() prints the valid error in
notice, but calling ocierror returns always ORA-24315 illegal attribute
type:
Warning: OCIStmtExecute: ORA-00942: table or view does not exist in
c:\www\ocierror_bug.php on line 20
ocierror($stmt): Array ( [code] => 24315 [message] => ORA-24315:
illegal attribute type [offset] => 17 [sqltext] => ) 1
2) doesn't return the sqltext item in the error array
The bug is in all PHP 4.3.x Windows versions.
3) invalid error offset returned
Reproduce code:
---------------
<?php
echo '<h1>PHP ocierror() bug</h1>';
$conn = ocilogon('user', 'passwd', 'host');
// execute error BEGIN
$stmt = ociparse($conn, "SELECT xyz12345 FROM no_table123");
ociexecute($stmt);
echo 'ocierror($stmt): ', print_r(ocierror($stmt)), '<br />';
ocifreestatement($stmt);
// execute error END
ocilogoff($conn);
?>
Expected result:
----------------
Warning: OCIStmtExecute: ORA-00942: table or view does not exist in
c:\www\ocierror_bug.php on line 20
ocierror($stmt): Array ( [code] => 942 [message] => ORA-00942: table or
view does not exist [offset] => 22 [sqltext] => SELECT xyz12345 FROM
no_table123) 1
Actual result:
--------------
Warning: OCIStmtExecute: ORA-00942: table or view does not exist in
c:\www\ocierror_bug.php on line 20
ocierror($stmt): Array ( [code] => 24315 [message] => ORA-24315:
illegal attribute type [offset] => 17 [sqltext] => ) 1
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=25123&edit=1
