Library > Products > Pervasive.SQL > Pervasive.SQL 9.1 > SQL Engine Reference > SQL Syntax Reference > OPEN

PreviousSQL Engine Reference (9.1 revision 1) Next

OPEN

Show this topic in Library frames

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.

Syntax 

OPEN cursor-name

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; 
......... 
OPEN cursor1; 
FETCH cursor1 INTO :CourseName; 
......... 
CLOSE cursor1; 
......... 


END

See Also

CREATE PROCEDURE

CREATE TRIGGER

DECLARE CURSOR

Chapter contents
Publication contents

Prev topic: NOT
Next topic: PRIMARY KEY