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

_{This page is licensed: GPLv2, originally from fill_help_tables.sql}