PHP: How to bind complex CollectionType-Object to Oracle -
i've got problem bind complex nested table-type php.
my oracle types:
create or replace type my.ot_my_status object ( id_nk number, status char(1) ); create or replace type my.ct_my_status table of ot_my_status;
and tried bind parameter type in php 5.5:
$coll = oci_new_collection($conn, "ct_my_status", "my"); //sampledata $data = new array(); $oneentry = new object(); $oneentry->id_nk = 12345; $oneentry->status = "1"; $data[] = $oneentry; //*********** $coll->append($data); //here crashes :-( oci_bind_by_name ( $stmt, ":coll", $coll, -1, oci_b_nty);
i can't append object-array collection.
oci-collection::append() expects parameter 1 string, object given
any ideas?
ase said here: http://php.net/manual/en/oci-collection.append.php
"the value added collection. can string or number."
Comments
Post a Comment