#25123 [Fbk->Opn]: ocierror() returns always ORA-24315 illegal attribute type

ID: 25123 User updated by: karel dot miarka at issa dot cz Reported By: karel dot miarka at issa dot cz -Status: Feedback +Status: Open Bug Type: OCI8 related Operating System: Windows 2000 PHP Version: 4CVS-2003-12-15 New Comment: Still invalid. There's maybe problem between the Oracle 8.1 Windows client and the Oracle 8.0 Linux server, because it works fine on Linux. 4.3.5RC2-dev PHP ocierror() bug OCIDebug: _oci_open_server new conn=0 dname=xxx OCIDebug: _oci_open_session new sess=3 user=yyy OCIDebug: oci_do_connect: id=4 OCIDebug: oci_parse "SELECT xyz12345 FROM no_table123" id=5 conn=4 Warning: ociexecute(): OCIStmtExecute: ORA-00942: tabulka nebo pohled neexistuje in c:\www\tests\ocierror.php on line 12 ocierror($stmt): Array ( [code] => 24315 [message] => ORA-24315: neplatný typ atributu [offset] => 21 [sqltext] => ) 1 OCIDebug: START _oci_stmt_list_dtor: id=5 last_query="SELECT xyz12345 FROM no_table123" OCIDebug: END _oci_stmt_list_dtor: id=5 OCIDebug: START php_rshutdown_oci OCIDebug: END php_rshutdown_oci OCIDebug: START _oci_conn_list_dtor: id=4 OCIDebug: nothing to do.. OCIDebug: END _oci_conn_list_dtor: id=4 OCIDebug: START _oci_close_session: logging-off sess=3 OCIDebug: START _oci_close_server: detaching conn=2 dbname=xxx Previous Comments: ------------------------------------------------------------------------ [2004-01-12 07:07:25] sniper@php.net 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 ------------------------------------------------------------------------ [2003-12-16 09:00:35] karel dot miarka at issa dot cz Output of the "reproduce code" (see below) when ociinternaldebug(1) called first: OCIDebug: _oci_open_server new conn=0 dname=xyz OCIDebug: _oci_open_session new sess=3 user=xyz123 OCIDebug: oci_do_connect: id=4 OCIDebug: oci_parse "SELECT xyz12345 FROM no_table123" id=5 conn=4 Warning: ociexecute(): OCIStmtExecute: ORA-00942: table or view doesn't exist in c:\www\tests\ocierror.php on line 10 ocierror($stmt): Array ( [code] => 24315 [message] => ORA-24315: illegal attribute type [offset] => 21 [sqltext] => ) 1 OCIDebug: START _oci_stmt_list_dtor: id=5 last_query="SELECT xyz12345 FROM no_table123" OCIDebug: END _oci_stmt_list_dtor: id=5 OCIDebug: START php_rshutdown_oci OCIDebug: END php_rshutdown_oci OCIDebug: START _oci_conn_list_dtor: id=4 OCIDebug: nothing to do.. OCIDebug: END _oci_conn_list_dtor: id=4 OCIDebug: START _oci_close_session: logging-off sess=3 OCIDebug: START _oci_close_server: detaching conn=2 dbname=xyz ------------------------------------------------------------------------ [2003-12-15 16:55:12] sniper@php.net Try the ociinternaldebug(1); like suggested by cjbj at hotmail dot com ------------------------------------------------------------------------ [2003-12-15 09:37:14] karel dot miarka at issa dot cz Our Oracle server version is 8.0.5.0.0 , so maybe that's the problem, but it was working fine with older versions of php. ------------------------------------------------------------------------ [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? ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/25123 -- Edit this bug report at http://bugs.php.net/?id=25123&edit=1