To use a cursor to process multiple rows returned by a select statement, first declare a reference variable to a cursor object. Then reference this variable in all of the cursor statements (open, close, fetch, update, and delete). You can use the declared reference variable throughout an application to perform parts of the cursor operations in different parts of the application. The cursor object includes several attributes that give information about the state of the cursor.

For a discussion of using cursors in OpenROAD, see the Programming Guide.