13.6.6.1 Cursor CLOSE Statement语句

CLOSE cursor_name

This statement closes a previously opened cursor. 此语句关闭以前打开的指针。For an example, see Section 13.6.6, “Cursors”.有关示例,请参阅第13.6.6节,“指针”

An error occurs if the cursor is not open.如果光标未打开,则会发生错误。

If not closed explicitly, a cursor is closed at the end of the BEGIN ... END block in which it was declared.如果没有显式关闭,则在其中声明的BEGIN ... END块结束时关闭指针。