oracle complex type and oci_new_collection
| From: | argoo | Date: | Tue, 27 Sep 2005 21:55:38 +0000 |
| Subject: | oracle complex type and oci_new_collection | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-40386@lists.php.net to get a copy of this message | ||
Is it possible to use a complex collection in PHP as shown below?
Oci_new_collection is successful, but the OCI-Collection->getElem(i) returns
false for each record returned. If we change from a complex type to a simple
type, the data returns as expected.
-----------------------------------------------------------------------------------------------------------------------------
-- COMPLEX TYPE
-----------------------------------------------------------------------------------------------------------------------------
create or replace type aud_cl_clu_row
as object
(
channel_line_up varchar2(50),
audit_status varchar2(20)
);
create or replace type aud_cl_clu_tbl is table of aud_cl_clu_row;
-----------------------------------------------------------------------------------------------------------------------------
-- SIMPLE TYPE
-----------------------------------------------------------------------------------------------------------------------------
create or replace type aud_cl_clu_tbl is table of varchar2(50);