Difference between revisions of "CURSORNAME()"
From Recital Documentation Wiki
Helengeorge (Talk | contribs) (→Class) |
Helengeorge (Talk | contribs) |
||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
==Purpose== | ==Purpose== | ||
Function to return the name of the cursor open in a workarea with an active gateway | Function to return the name of the cursor open in a workarea with an active gateway | ||
| Line 35: | Line 33: | ||
==Products== | ==Products== | ||
| − | Recital | + | Recital Server, Recital |
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
Revision as of 16:36, 27 November 2009
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
