Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

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 , 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.

print $arr->size()."\n";
Just says that the size is 0.

Is there a way to get the array, with php commands or sql?

Site Timeline