sa_list_cursors system procedure

sa_list_cursors( )

Column name	Data type	Description
handle	UNSIGNED INT	A unique handle identifying the cursor.
scope	INTEGER	The scope of the call stack where the cursor is open.
cursor_name	VARCHAR(128)	The cursor name.
is_open	BIT	The indicator of whether the cursor is currently open (1).
is_pinned	BIT	The indicator of whether the cursor is currently pinned in memory (1) in anticipation of reuse.
fetch_count	UNSIGNED BIGINT	The number of rows that have been fetched from the cursor.

The sa_list_cursors system procedure can be used in a CALL statement or in the FROM clause of a SELECT statement.

None

The following example returns the list of open cursors for the connection:

CALL sa_list_cursors();