FINDCURSOR()

Class

Data Connectivity

Purpose

Returns the workarea number corresponding to the specified gateway cursor

Syntax

FINDCURSOR(<expC>)

See Also

CLOSE, CURSORNAME(), DECLARE CURSOR, DROP CURSOR, FETCH, GATEWAY(), OPEN CURSOR

Description

The FINDCURSOR() function returns a workarea number corresponding to the open gateway cursor specified by <expC>. If the cursor name specified is not open, or no gateway is active, then a value of -1 is returned.

Example

select 3
set gateway to "ora@sales:scott/tiger"
exec sql
declare employees cursor for
select empno, ename, job
from emp
order by deptno;
exec sql
open employees;
 
? findcursor(cursorname())
         3

Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer