executeCursor

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')
);