ID: 25123 Updated by: [EMAIL PROTECTED] Reported By: karel dot miarka at issa dot cz -Status: Open +Status: Feedback Bug Type: OCI8 related Operating System: Windows 2000 -PHP Version: 4.3.3RC5-dev, 5.0.0b2-dev +PHP Version: 4.3.3 New Comment:
Please try using this CVS snapshot: http://snaps.php.net/php4-STABLE-latest.tar.gz For Windows: http://snaps.php.net/win32/php4-win32-STABLE-latest.zip Previous Comments: ------------------------------------------------------------------------ [2003-09-22 03:47:14] cjbj at hotmail dot com Does not reproduce for me with PHP 4.3.3 on W2K using Oracle 9.2.0.1. Re SET AUTOTRACE, this is SQL*Plus specific and produces a simple tuning report I discovered PHP's OCI8 internal debug output can be enabled by calling ociinternaldebug(1). Maybe this will help the filer? ------------------------------------------------------------------------ [2003-08-29 09:13:59] karel dot miarka at issa dot cz I use Apache/1.3.24 for Windows 95/NT, and Oracle8 Release 8.0.5.0.0 - Production on Linux, but it behaves the same also under Oracle 8.1 for Windows. Autotrace seems to be SQL*plus feature only and in addition it seems to be off by default. The ocierror() behaves fine under PHP 4.2 on Windows. And there is no problem with ocierror() on Linux with PHP 4.3.3 . I have reported this bug on "PHP 4.3.x" and someone else has changed this my line to "4.3.3RC5-dev, 5.0.0b2-dev" so I guess this "unknown" person is a PHP-OCI8 developer who reproduced this error with those PHP version. ------------------------------------------------------------------------ [2003-08-29 08:44:48] guenter_doge at web dot de 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. ------------------------------------------------------------------------ [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