SQL-02117: Invalid SQL Cursor usage: trying to OPEN an OPENed cursor

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

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 18:45

SQL-02117：无效的SQL Cursor用法：尝试打开OPENed游标,
.原因：尝试打开已经使用MODE = {ANSI | ANSI14 | ANSI13}打开的光标。只有在MODE = ORACLE时，才能重新打开打开的光标。,
.操作：当MODE = {ANSI | ANSI14 | ANSI13}时，在尝试打开光标前，请确认光标尚未打开。指定MODE = ORACLE，如果OPENed光标要重新打开。,
.

aiaiDBA

13718043309

010-86462881

SQL-02117: Invalid SQL Cursor usage: trying to OPEN an OPENed cursor

1 个回答

相似问题