OPEN

Syntax

Current

OPEN cursor_name [[USING variable[,...]] | [expression[,...]]];

Oracle Mode

< 10.3

Description

This statement opens a cursor which was previously declared with DECLARE CURSOR.

The query associated to the DECLARE CURSOR is executed when OPEN is executed. It is important to remember this if the query produces an error, or calls functions which have side effects.

This is necessary in order to FETCH rows from a cursor.

See Cursor Overview for an example.

See Also

• Cursor Overview

• DECLARE CURSOR

• FETCH cursor_name

• CLOSE cursor_name

• Cursors in Oracle mode

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