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.7. 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