Do you have a question? Post it now! No Registration Necessary. Now with pictures!
March 23, 2005, 3:30 pm
rate this thread
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');
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.
Just says that the size is 0.
Is there a way to get the array, with php commands or sql?