SQL Syntax Reference : OPEN
 
OPEN
Syntax
OPEN cursor-name
 
cursor-name ::= user-defined-name
Remarks
The OPEN statement opens a cursor. A cursor must be defined before it can be opened.
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 opens the declared cursor BTUCursor.
DECLARE BTUCursor CURSOR
FOR SELECT Degree, Residency, Cost_Per_Credit FROM Tuition ORDER BY ID;
OPEN BTUCursor;
============ 
CREATE PROCEDURE MyProc(IN :CourseName CHAR(7)) AS
BEGIN
DECLARE cursor1 CURSOR
FOR SELECT Degree, Residency, Cost_Per_Credit FROM Tuition ORDER BY ID;
(additional code would go here)
OPEN cursor1;
FETCH cursor1 INTO :CourseName;
(additional code would go here)
CLOSE cursor1;
(additional code would go here)
END
See Also
CREATE PROCEDURE
CREATE TRIGGER
DECLARE CURSOR