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

Products

Recital Server, Recital