for游标时不需要手动open,close游标
一、查看循环中打开的游标有一个相应的关闭; 二、如果没有inserting/updating/deleting,不需要commit语句; 三、每个fetch后都应该有一个Exit when name_of_cursor%notfound语句; 四、循环中需要紧接着CLOSE子句; 参考》http://blog.csdn.net/xyj0808xyj/article/details/52139937...
oracle循环调用存储过程出现ORA-06511: PL/SQL: 游标已经打开,for游标时不需要手动open,close游标...
将日志id放入@NLId游标中 declare cursorNLId cursor for select NoteLogId from NoteLogs where NUId...
Recursive_Func(r_Test.column)); END IF; END LOOP; RETURN Value; END Recursive_Func; END TEST; / --- The result is The result is ORA-06511: PL/SQL: cursor already open
ORA-06511: PL/SQL: cursor already open ORA-06512: at "APPS.XX_PUSH_DATA_PR", line 4 ORA-06512: at "APPS.XX_PUSH_DATA_PR", line 19 ORA-06512: at line 2 06511. 00000 - "PL/SQL: cursor already open" *Cause: An attempt was made to open a cursor that was already open. ...
ORA-06511 in recursive routine Hi, I am opening a cursor in a recursive function: --- CREATE OR REPLACE PACKAGE TEST AUTHID CURRENT_USER AS FUNCTION Recursive_Func (param VARCHAR2) RETURN VARCHAR2; END TEST; / CREATE OR REPLACE PACKAGE BODY...