I need to know how to get a collection (varray), basically it's an
array of chars with size of 9999 positions, from oracle so I can use
it as an array with php. There's very little documentation about it.
The only thing I found was
http://conf.php.net/pres/slides/oci/paper.txt , but only talks about
putting an array on the database, not getting it.
I tried this:
$arr = OCINewCollection($db,'VARCHAR2_V','SCHEMA');
$stmt=ociparse($db,$query_sql);
OCIDefineByName($stmt,'VFIELD',$arr);
OCIExecute($stmt);
But no luck.
VARCHAR2_V is the varray type.
The variable $query_sql is a simple SELECT of the VARRAY, and in SQL
Navigator works just fine.
print $arr->size()."\n";
Just says that the size is 0.
Is there a way to get the array, with php commands or sql?
