Hi! I have an oracle object type as follows,
create or replace type my_objtype as object (col1 number, col2 number) / create or replace type my_arrtype as table of my_objtype / I couldn't get this bound in php. If I have an simple oracle object type (see the below one), I could bind it and pass the object to oracle procedure. create or replace type my_arrtype as table of number; How do I bind if my object is a NESTED TABLE OF OBJECTS (my_arrtype).? code snippet: =========== <? $arr = OCINewCollection($conn,'MY_ARRTYPE'); //populate the $arr. Note: I tried various ways here. $arr->append(array(10,100)); $arr->append(array(20,200)); $stmt = OCIParse($conn,"begin my_p(:my_arrBindVar); end;" ) ; arr->append(array(10,100)); $ok = OCIBindByName($stmt,':my_arrBindVar',&$arr,32,OCI_B_SQLT_NTY); //$ok = OCIBindByName($stmt,':my_arrBindVar',$arr,32,OCI_B_SQLT_NTY); OciExecute($stmt,OCI_DEFAULT); ?> I get the following error: "Call to a member function on a non-object in ..." Thanks. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php