# 22. Virtuoso Functions Guide - bookmark

Chapter Contents | Prev | Next
Keyword Search:
www.openlinksw.com
docs.openlinksw.com
Book Home
Contents
Preface
Virtuoso Functions Guide
Administration
Aggregate Functions
Array Manipulation
BPEL APIs
Backup
Compression
Cursor
bookmark
Date & Time Manipulation
Debug
Dictionary Manipulation
Encoding & Decoding
File Manipulation
Free Text
Hashing / Cryptographic
LDAP
Locale
Mail
Miscellaneous
Number
Remote SQL Data Source
Replication
SOAP
SQL
String
Transaction
Type Mapping
UDDI
User Defined Types & The CLR
Virtuoso Java PL API
Virtuoso Server Extension Interface (VSEI)
Web Server & Internet
XML
XPATH & XQUERY
Functions Index

## bookmark

Return the bookmark for current row of a scrollable cursor
any bookmark (in cursor CURSOR);
Parameters
–
Return Types

integer bookmark id.

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.

Errors

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