SQL-02114: Invalid SQL Cursor usage: trying to CLOSE a CLOSEd cursor

SQL-02114: Invalid SQL Cursor usage: trying to CLOSE a CLOSEd cursor
Cause: An attempt was made to CLOSE a cursor that was already CLOSEd with MODE={ANSI|ANSI14}. A CLOSEd cursor can be re-CLOSEd only when MODE={ORACLE|ANSI13}.
Action: When MODE={ANSI|ANSI14}, verify that a cursor is not already CLOSEd before trying to CLOSE it. Specify MODE={ORACLE|ANSI13} if a CLOSEd cursor is to be re-CLOSEd.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 18:45

SQL-02114：SQL游标使用无效：尝试关闭一个CLOSEd游标,
.原因：尝试关闭已使用MODE = {ANSI | ANSI14}关闭的游标。只有当MODE = {ORACLE | ANSI13}时，才能重新关闭CLOSE。,
.操作：当MODE = {ANSI | ANSI14}时，请在尝试关闭之前验证光标是否尚未关闭。如果要将CLOSEd光标重新关闭，请指定MODE = {ORACLE | ANSI13}。,
.

aiaiDBA

13718043309

010-86462881

SQL-02114: Invalid SQL Cursor usage: trying to CLOSE a CLOSEd cursor

1 个回答

相似问题