|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
[2006-09-12 16:36 UTC] tony2001@php.net
|
|||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Mon Nov 03 07:00:01 2025 UTC |
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