Skip to main content

CLOSE

Closes a cursor.

Syntax​

CLOSE <cursor_name>;

Description​

After a cursor is closed, the resources associated with the cursor are released.

When a transaction is stopped by COMMIT or ROLLBACK, all non-holdable open cursors are implicitly closed. When a transaction is stopped by COMMIT, the open cursor created by the transaction are implicitly closed. When a transaction successfully commits, the holdable cursor created by the transaction is still open until CLOSE is run or the client disconnects.

info

After a cursor is declared by using DECLARE, it is open by default since Relyt does not provide an OPEN statement for cursors.

Parameters​

<cursor_name>: the name of the open cursor.

Examples​

Close the cursor my_cursor:

CLOSE my_cursor;

SQL standard compatibility​

CLOSE in Relyt is fully compatible with standard SQL CLOSE.