OPEN cursor_name [expression[,...]];OPEN cursor_nameThis statement opens a which was previously declared with .
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 rows from a cursor.
See for an example.
This page is licensed: GPLv2, originally from