====== executeCursor ======
~~NOTOC~~
== Syntax ==
resource executeCursor(
string $sql,
optional string $cursorName='rs',
optional mixed $params=false
)
===== Description =====
This Oracle only method calls an oracle stored procedure and returns a cursor variable as a recordset.
------------------------------------
===== Usage =====
/*
* Note: we return a cursor variable in :RS2
*/
$rs = $db->ExecuteCursor("BEGIN adodb.open_tab(:RS2); END;",'RS2');
$rs = $db->ExecuteCursor("BEGIN :RS2 = adodb.getdata(:VAR1); END;",
'RS2',
array('VAR1' => 'Mr Bean')
);