Name
bookmark — Return the bookmark for current row of a scrollable cursor
Synopsis
any
bookmark
(
|
in
cursor
CURSOR
); |
Description
bookmark
returns a bookmark for the current row
of an open scrollable cursor. Given an invalid argument, i.e. no cursor,
no current row or non-open cursor, it signals an error. The returned
value can be used in subsequent FETCH .. BOOKMARK over the same
cursor.
Parameters
bookmark
Given Bookmark.
cursor
Open scrollable cursor.
Return Types
integer
bookmark id.
Errors
Table 24.8. Errors signalled by
| SQLState | Error Code | Error Text | Description |
|---|---|---|---|
| 24000 | SR238 | Virtuoso/PL Scrollable cursor not opened | |
| HY109 | SR239 | Virtuoso/PL Scrollable cursor not positioned on a row |
See Also
Cursors in Virtuoso/PL guide