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 = OCINewCollectio n($db,'VARCHAR2 _V','SCHEMA');
$stmt=ociparse( $db,$query_sql) ;
OCIDefineByName ($stmt,'VFIELD' ,$arr);
OCIExecute($stm t);
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?
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 = OCINewCollectio n($db,'VARCHAR2 _V','SCHEMA');
$stmt=ociparse( $db,$query_sql) ;
OCIDefineByName ($stmt,'VFIELD' ,$arr);
OCIExecute($stm t);
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?