| Hal McFarlane 2005-09-28, 6:57 pm |
| 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);
|