ID: 25123 User updated by: karel dot miarka at issa dot cz Reported By: karel dot miarka at issa dot cz -Status: Feedback +Status: Closed Bug Type: OCI8 related Operating System: Windows 2000 PHP Version: 4CVS-2003-12-15 New Comment:
Oracle Home Selector said: "There is only one (1) Oracle home defined on this machine and, therefore, this tool cannot change your primary Oracle home." > You're using WinNT/2000 and multiple oracles, am I right? Yes and no. I'm using W2K and I have only one Oracle 8.1 server + client installed localy. But I usually use only the client for connections to a Linux server with Oracle 8.0.5.0.0. Now, I have tried to run the error-test script against the local Oracle version, but the results is still the same ORA-00942 warning is printed, but ORA-24315 is reported by ocierror(). Ok guys, lets close this "bug" it is probably only a local problem of my computer configuration or the older Oracle versions. Previous Comments: ------------------------------------------------------------------------ [2004-01-15 10:22:02] [EMAIL PROTECTED] It seems, that this is not PHP bug, http://users.pandora.be/jbosman/jbsql/ - this page says, that "If you get "ORA-24315: illegal attribute type" every time you get another Oracle error, then you don't have the Oracle 8i home as your primary Oracle home. Use the Oracle Home Selector to change it". I'm not able to check if this is true, 'cause there is no such old Oracle around. Check it, plz. ------------------------------------------------------------------------ [2004-01-13 03:44:38] karel dot miarka at issa dot cz 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 ------------------------------------------------------------------------ [2004-01-12 07:07:25] [EMAIL PROTECTED] 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] [EMAIL PROTECTED] Try the ociinternaldebug(1); like suggested by cjbj at hotmail dot com ------------------------------------------------------------------------ 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
