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