From: ces dot fci at gmail dot com
Operating system: any
PHP version: 5.1.6
PHP Bug Type: OCI8 related
Bug description: oci_new_collection is working incorrectly
Description:
------------
I am trying to use oci_new_collection but I have not yet had any success.
I have only been able to test it up to PHP 5.1.4. I found a post on Google
Groups that suggests "it works only for VARRAY types"(Mladen Gogala).
Reproduce code:
---------------
$dbh = oci_connect('apps', '..', "(DESCRIPTION = (ADDRESS_LIST = (ADDRESS
= (PROTOCOL = TCP)(Host = ..)(Port = 1522))) (CONNECT_DATA =(SID =
test)))");
oci_new_collection($dbh, 'HZ_PARTY_SEARCH.CONTACT_POINT_LIST', 'APPS');
In PL/SQL the collection is declared as:
TYPE contact_point_list IS TABLE OF contact_point_search_rec_type
INDEX BY BINARY_INTEGER;
TYPE contact_point_search_rec_type IS RECORD (
CONTACT_POINT_TYPE VARCHAR2(30) -- HZ_CONTACT_POINTS
,CPT_SOURCE_SYSTEM_REF VARCHAR2(4000) -- CUSTOM
,TELEPHONE_TYPE VARCHAR2(30) -- HZ_CONTACT_POINTS
,TELEX_NUMBER VARCHAR2(50) -- HZ_CONTACT_POINTS
/* . . . */
,WEB_TYPE VARCHAR2(60) -- HZ_CONTACT_POINTS
,STATUS VARCHAR2(1) -- HZ_CONTACT_POINTS
,CONTACT_POINT_PURPOSE VARCHAR2(30) -- HZ_CONTACT_POINTS
);
Expected result:
----------------
I do not expect to experience any errors.
Actual result:
--------------
Warning: oci_new_collection() [function.oci-new-collection]: OCI-22303:
type "APPS"."HZ_PARTY_SEARCH.CONTACT_POINT_LIST" not found in
C:\wamp\www\test.php on line 18
--
Edit bug report at http://bugs.php.net/?id=38791&edit=1
--
Try a CVS snapshot (PHP 4.4):
http://bugs.php.net/fix.php?id=38791&r=trysnapshot44
Try a CVS snapshot (PHP 5.2):
http://bugs.php.net/fix.php?id=38791&r=trysnapshot52
Try a CVS snapshot (PHP 6.0):
http://bugs.php.net/fix.php?id=38791&r=trysnapshot60
Fixed in CVS: http://bugs.php.net/fix.php?id=38791&r=fixedcvs
Fixed in release:
http://bugs.php.net/fix.php?id=38791&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=38791&r=needtrace
Need Reproduce Script: http://bugs.php.net/fix.php?id=38791&r=needscript
Try newer version: http://bugs.php.net/fix.php?id=38791&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=38791&r=support
Expected behavior: http://bugs.php.net/fix.php?id=38791&r=notwrong
Not enough info:
http://bugs.php.net/fix.php?id=38791&r=notenoughinfo
Submitted twice:
http://bugs.php.net/fix.php?id=38791&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=38791&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=38791&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=38791&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=38791&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=38791&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=38791&r=float
No Zend Extensions: http://bugs.php.net/fix.php?id=38791&r=nozend
MySQL Configuration Error: http://bugs.php.net/fix.php?id=38791&r=mysqlcfg
