ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


v5:database:oracle:executecursor

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.txt · Last modified: 2016/01/17 01:56 by mnewnham