oracle complex type and oci_new_collection

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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); 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux