CURSORNAME()

Purpose

Function to return the name of the cursor open in a workarea with an active gateway

Syntax

CURSORNAME([<workarea | alias>])

See Also

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

Description

The CURSORNAME() function returns the cursor name corresponding to the workarea specified by <workarea | alias>. If there is no cursor open, or no gateway active in the specified workarea then an empty string is returned. If no <workarea | alias> is specified then the CURSORNAME() function defaults to the current workarea.

Example

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;
 
? cursorname()
EMPLOYEES

Products

Recital Server, Recital