FINDCURSOR()

From Recital Documentation Wiki
Revision as of 11:50, 22 June 2010 by Yvonnemilne (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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


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"
declare employees;
  cursor for;
  select empno, ename, job;
  from emp;
  order by deptno
open employees
 
? findcursor(cursorname())
         3


Products

Recital Server, Recital