CLOSE

Remarks

The CLOSE statement closes an open SQL cursor.

The cursor that the cursor name specifies must be open.

This statement is allowed only inside of a stored procedure or a trigger, since cursors and variables are only allowed inside of stored procedures and triggers.

Examples

The following example closes the cursor BTUCursor.

CLOSE BTUCursor; 

See Also

OPEN

CREATE PROCEDURE

CREATE TRIGGER