#28944 [Asn->Csd]: OCITypeByName: OCI-21522 with two connections

ID: 28944 Updated by: tony2001@php.net Reported By: manuel at pincho dot org -Status: Assigned +Status: Closed Bug Type: OCI8 related Operating System: Linux PHP Version: 5.*, 4.* Assigned To: tony2001 New Comment: The bug has been fixed in OCI8 v.1.1, which is available in CVS HEAD and PECL (use pear install oci8-beta to install it). Previous Comments: ------------------------------------------------------------------------ [2004-08-17 10:44:31] manuel at pincho dot org I download php4-STABLE-200408170630.tar.bz2 and php5-200408170630.tar.bz2 I execute the example script with the corrent user, pass and SID. /usr/local/src/php4-STABLE-200408170630/sapi/cli/php /tmp/x.php Warning: ocinewcollection(): OCITypeByName: OCI-21522: attempted to use an invalid connection in OCI (object mode only) in /tmp/x.php on line 5 and /usr/local/src/php5-200408170630/sapi/cli/php /tmp/x.php Warning: ocinewcollection(): OCITypeByName: OCI-21522: attempted to use an invalid connection in OCI (object mode only) in /tmp/x.php on line 5 If I make one conection It works. ------------------------------------------------------------------------ [2004-08-13 17:48:41] tony2001@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 Please, try with the latest version first. ------------------------------------------------------------------------ [2004-06-28 11:25:19] manuel at pincho dot org Description: ------------ When I use ocinewcollection and I have to connections or more open in the same php with the same user,password and SID ; ocinewcollection fails with Warning: ocinewcollection(): OCITypeByName: OCI-21522: attempted to use an invalid connection in OCI (object mode only) Oracle version is 9.2.0.4 PHP 4.3.6: './configure' '--with-apache=/usr/local/src/apache_1.3.29' '--with-oci8=/u01/app/oracle/product/9.2.0' '--with-mnogosearch=/usr/local/mnogosearch' '--with-mysql' '--with-gd' '--with-jpeg-dir' '--with-png-dir' '--with-zlib-dir' '--enable-track-vars' '--enable-sigchild' '--enable-xml' '--enable-inline-optimization' '--enable-memory-limit' '--disable-debug' Reproduce code: --------------- // CREATE OR REPLACE TYPE local_id_array AS TABLE OF NUMBER(11); $db =OCIPLogon('XXX','XXX','XXX'); $db2=OCIPLogon('XXX','XXX','XXX'); $coll = ocinewcollection ($db2,'LOCAL_ID_ARRAY'); Actual result: -------------- Warning: ocinewcollection(): OCITypeByName: OCI-21522: attempted to use an invalid connection in OCI (object mode only) ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=28944&edit=1