Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Usage » Using Procedures, Triggers, and Batches

Returning variable result sets from procedures Next Page

Using cursors in procedures and triggers


Cursors retrieve rows one at a time from a query or stored procedure with multiple rows in its result set. A cursor is a handle or an identifier for the query or procedure, and for a current position within the result set.


Cursor management overview
Using cursors on SELECT statements in procedures
Updating a cursor inside a stored procedure