CLOSE

Syntax

CLOSE cursor_name

Description

This statement closes a previously opened cursor. The cursor must have been previously opened or else an error occurs.

If not closed explicitly, a cursor is closed at the end of the compound statement in which it was declared.

See Cursor Overview for an example.

See Also

• Cursor Overview
• DECLARE CURSOR
• OPEN cursor_name
• FETCH cursor_name
• Cursors in Oracle mode