ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


v5:database:oracle:executecursor

This is an old revision of the document!


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')
);
v5/database/oracle/executecursor.1448940948.txt.gz · Last modified: 2017/04/21 11:26 (external edit)