Posted by naph on 11/01/11 11:32

Hi, I've had this problem, and managed to solve it now (i don't know
how well yet, but it works) so i thought i'd post the solution because
i couldn't find it anywhere.

The problem I was having was we have lots of functions that return
sys_refcursor's that we use as recordsets through ADO with a windows
application, but then we needed to call these same functions from PHP,
so the solution was to use cursors, like so...

<?

$cnn = OCILogon( 'User', Password', 'TNS' );
$cur = OCINewCursor( $cnn );
$stmt = OCIParse( $cnn, " begin :MyRefCur := MyFunction( 1, 2, 3 );
end; " );

OCIBindByName( $stmt, ":MyRefCur", $cur, -1, OCI_B_CURSOR );
OCIExecute( $stmt );
OCIExecute( $cur );

while ( OCIFetchInto($cur,$row,OCI_ASSOC) )
foreach ( $row as $name => $value )
echo "$name = '$value'<br />";

OCIFreeStatement( $stmt );
OCIFreeCursor( $cur );
OCILogoff( $cnn );

?>

Maybe someone else has a better solution?

[Back to original message]