ID: 26892 Updated by: [EMAIL PROTECTED] Reported By: tomy at envox dot hr -Status: Open +Status: Feedback Bug Type: OCI8 related Operating System: Suse 8.2 PHP Version: 4CVS-2004-01-13 (stable) New Comment:
Please try using this CVS snapshot: http://snaps.php.net/php5-latest.tar.gz For Windows: http://snaps.php.net/win32/php5-win32-latest.zip The *COLLECTIONS* defines have been fixed. Previous Comments: ------------------------------------------------------------------------ [2004-01-13 13:44:58] [EMAIL PROTECTED] Please, try PHP5 latest snapshots and check if it works with them. ------------------------------------------------------------------------ [2004-01-13 11:24:47] tomy at envox dot hr Did some trial/error testing with earlier PHP versions and found out that this problem does not exist with version 4.3.1, appears in version 4.3.2 and exists ever since... It is even possible to bypass it by copying 4.3.1 oci extension source to latest CVS snapshot and then the problem does not exist anymore. Also it seems, although I cannot confirm that with 100% certainity, that it only exists if 9.2 client is used by php. It seems that 8.0 client is not affected. Hope this helps. ------------------------------------------------------------------------ [2004-01-13 06:42:04] tomy at envox dot hr Forgot to mention my oci data from phpinfo...: OCI8 Support enabled Revision $Revision: 1.183.2.7 $ Oracle Version 9.2 Compile-time ORACLE_HOME /opt/oracle/product/9ir2 Libraries Used no value ------------------------------------------------------------------------ [2004-01-13 06:37:08] tomy at envox dot hr Description: ------------ ocinewcollection returns false and produces a warning, output with oci debug enabled follows in actual result. I have checked in source and using oci_debug that OCIInitialize is called using OCI_DEFAULT | OCI_OBJECT so I do not understand why this error happens. PHP is compiled using this configure: " './configure' '--enable-sigchild' '--disable-static' '--enable-track-vars' '--enable-trans-sid' '--enable-sockets' '--with-mysql' '--with-xml' '--disable-rpath' '--disable-pic' '--disable-posix' '--with-zlib' '--without-pear' '--without-aspell' '--disable-dbase' '--disable-dba' '--without-mhash' '--without-gmp' '--with-gnu-ld' '--disable-bcmath' '--without-cdb' '--without-db3' '--without-db2' '--without-gdbm' '--without-ndbm' '--without-dbm' '--without-dom' '--enable-mbstring' '--enable-mbstr-enc-trans' '--with-recode' '--with-gd' '--enable-shmop' '--enable-sysvsem' '--with-xmlrpc' '--with-oci8' '--with-mcrypt' '--with-apxs' " LOCAL_ID_ARRAY is defined as: " CREATE OR REPLACE TYPE local_id_array AS TABLE OF NUMBER(11); " Reproduce code: --------------- $_db_tns = "(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.3.41)(PORT=1521)))(CONNECT_DATA=(SID=pirana)(SERVER=DEDICATED)))"; $_db_user = "system"; $_db_pwd = "pirana"; ociinternaldebug(1); $db = ocinlogon($_db_user, $_db_pwd, $_db_tns); $arr = ocinewcollection($db, 'LOCAL_ID_ARRAY'); if ($arr === false) echo "Collection failed<br>"; Expected result: ---------------- I expect only oci debug data to be written. Actual result: -------------- $arr should be OCI-Collection however it is false. Actual output is: " OCIDebug: _oci_open_server new conn=0 dname=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.3.41)(PORT=1521)))(CONNECT_DATA=(SID=pirana)(SERVER=DEDICATED))) OCIDebug: _oci_open_session new sess=5 user=system OCIDebug: oci_do_connect: id=6 Warning: ocinewcollection(): OCITypeByName: ORA-21301: not initialized in object mode in /srv/www/htdocs/envox/info2.php on line 18 Collection failed OCIDebug: START php_rshutdown_oci OCIDebug: END php_rshutdown_oci OCIDebug: START _oci_coll_list_dtor: 7 OCIDebug: START _oci_conn_list_dtor: id=6 OCIDebug: nothing to do.. OCIDebug: START _oci_close_session: logging-off sess=5 OCIDebug: END _oci_conn_list_dtor: id=6 OCIDebug: END _oci_coll_list_dtor: 7 OCIDebug: START _oci_close_server: detaching conn=4 dbname=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.3.41)(PORT=1521)))(CONNECT_DATA=(SID=pirana)(SERVER=DEDICATED))) " ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=26892&edit=1
