|  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #26892 ocinewcollection fails with Oracle 9.2
Submitted: 2004-01-13 06:37 UTC Modified: 2004-01-15 10:10 UTC
Avg. Score:5.0 ± 0.0
Reproduced:2 of 2 (100.0%)
Same Version:2 (100.0%)
Same OS:2 (100.0%)
From: tomy at envox dot hr Assigned: tony2001 (profile)
Status: Closed Package: OCI8 related
PHP Version: 4CVS-2004-01-13 (stable) OS: Suse 8.2
Private report: No CVE-ID: None
View Add Comment Developer Edit
Anyone can comment on a bug. Have a simpler test case? Does it work for you on a different platform? Let us know!
Just going to say 'Me too!'? Don't clutter the database with that please !
Your email address:
Solve the problem:
42 + 36 = ?
Subscribe to this entry?

 [2004-01-13 06:37 UTC] tomy at envox dot hr
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:

Reproduce code:
$_db_user = "system";
$_db_pwd = "pirana";

   $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=
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=


Add a Patch

Pull Requests

Add a Pull Request


AllCommentsChangesGit/SVN commitsRelated reports
 [2004-01-13 06:42 UTC] tomy at envox dot hr
Forgot to mention my oci data from phpinfo...:
OCI8 Support  enabled  
Revision  $Revision: $  
Oracle Version  9.2  
Compile-time ORACLE_HOME  /opt/oracle/product/9ir2  
Libraries Used  no value
 [2004-01-13 11:24 UTC] 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 13:44 UTC]
Please, try PHP5 latest snapshots and check if it works with them.
 [2004-01-15 01:26 UTC]
Please try using this CVS snapshot:
For Windows:

The *COLLECTIONS* defines have been fixed.

 [2004-01-15 03:47 UTC] tomy at envox dot hr
The *COLLECTIONS* defines have NOT been fixed!!!
At least not in php5-200401150630 found in

You still define HAVE_OCI8_COLLECTIONS in configure and use PHP_OCI8_HAVE_COLLECTIONS in ext/oci8/oci8.c. Also have HAVE_OCI8_COLLECTIONS in all other files and once in ext/oci8/oci8.c. The one use of HAVE_OCI8_COLLECTIONS is conviniently placed in PHP_MINFO_FUNCTION so phpinfo() says that collection support is enabled. However all collection methods are wrapped inside PHP_OCI8_HAVE_COLLECTIONS so they are actually not present.

Simple recursive search yields:

Find 'PHP_OCI8_HAVE_COLLECTIONS' in 'ext/oci8/oci8.c' :
ext/oci8/oci8.c/84: #ifdef PHP_OCI8_HAVE_COLLECTIONS 
ext/oci8/oci8.c/90: #ifdef PHP_OCI8_HAVE_COLLECTIONS
ext/oci8/oci8.c/193: #ifdef PHP_OCI8_HAVE_COLLECTIONS
ext/oci8/oci8.c/208: #ifdef PHP_OCI8_HAVE_COLLECTIONS
ext/oci8/oci8.c/262: #ifdef PHP_OCI8_HAVE_COLLECTIONS
ext/oci8/oci8.c/351: #ifdef PHP_OCI8_HAVE_COLLECTIONS
ext/oci8/oci8.c/434: #ifdef PHP_OCI8_HAVE_COLLECTIONS
ext/oci8/oci8.c/484: #ifdef PHP_OCI8_HAVE_COLLECTIONS
ext/oci8/oci8.c/523: #ifdef PHP_OCI8_HAVE_COLLECTIONS
ext/oci8/oci8.c/602: #ifdef PHP_OCI8_HAVE_COLLECTIONS
ext/oci8/oci8.c/608: #ifdef PHP_OCI8_HAVE_COLLECTIONS
ext/oci8/oci8.c/616: #ifdef PHP_OCI8_HAVE_COLLECTIONS
ext/oci8/oci8.c/648: #ifdef PHP_OCI8_HAVE_COLLECTIONS
ext/oci8/oci8.c/655: #ifdef PHP_OCI8_HAVE_COLLECTIONS
ext/oci8/oci8.c/660: #ifdef PHP_OCI8_HAVE_COLLECTIONS
ext/oci8/oci8.c/685: #ifdef PHP_OCI8_HAVE_COLLECTIONS
ext/oci8/oci8.c/1051: #ifdef PHP_OCI8_HAVE_COLLECTIONS
ext/oci8/oci8.c/1412: #ifdef PHP_OCI8_HAVE_COLLECTIONS
ext/oci8/oci8.c/3604: #ifdef PHP_OCI8_HAVE_COLLECTIONS
ext/oci8/oci8.c/3633: #ifdef PHP_OCI8_HAVE_COLLECTIONS
ext/oci8/oci8.c/3751: #ifdef PHP_OCI8_HAVE_COLLECTIONS
ext/oci8/oci8.c/6221: #ifdef PHP_OCI8_HAVE_COLLECTIONS

Find 'HAVE_OCI8_COLLECTIONS' in 'configure' :
configure/57304: #define HAVE_OCI8_COLLECTIONS 1
ext/oci8/config.m4/146:     AC_DEFINE(HAVE_OCI8_COLLECTIONS,1,[ ])
ext/oci8/oci8.c/806: #ifdef HAVE_OCI8_COLLECTIONS

Also after having fixed defines by replacing all PHP_OCI8_HAVE_COLLECTIONS with HAVE_OCI8_COLLECTIONS the original bug remains!!!!!!!!
 [2004-01-15 05:27 UTC]
The snapshot is too old. (the 'typo' is fixed in CVS, snapshot just doesn't have the changes in it yet)
Get the latest snapshot now.

 [2004-01-15 06:00 UTC] tomy at envox dot hr
The *COLLECTIONS* defines have been fixed now.

Unfortunately the original bug submitted still exists!

Output from reproducable script follows (ocinewcollection fails and returns false with a warning):
OCIDebug: _oci_open_server new conn=0 dname=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=
OCIDebug: _oci_open_session new sess=3 user=system
OCIDebug: oci_do_connect: id=4

Warning: ocinewcollection() [function.ocinewcollection]: OCITypeByName: ORA-21301: not initialized in object mode in /srv/www/htdocs/envox/info2.php on line 14
Collection failed
OCIDebug: START php_rshutdown_oci
OCIDebug: END php_rshutdown_oci
OCIDebug: START _oci_coll_list_dtor: 5
OCIDebug: END _oci_coll_list_dtor: 5
OCIDebug: START _oci_conn_list_dtor: id=4
OCIDebug: nothing to do..
OCIDebug: START _oci_close_session: logging-off sess=3
OCIDebug: END _oci_conn_list_dtor: id=4
 [2004-01-15 09:34 UTC]
I'm currently working on it.
 [2004-01-15 10:10 UTC]
This bug has been fixed in CVS.

Snapshots of the sources are packaged every three hours; this change
will be in the next snapshot. You can grab the snapshot at
Thank you for the report, and for helping us make PHP better.

Thanks for reporting.
PHP Copyright © 2001-2023 The PHP Group
All rights reserved.
Last updated: Thu Jun 08 05:03:37 2023 UTC