aiaiDBA

加微信获取免费职业规划+学习资料,了解年薪50万的DBA是如何练成的

13718043309

010-86462881

PLS-00404: cursor 'string' must be declared with FOR UPDATE to use with CURRENT OF

PLS-00404: cursor 'string' must be declared with FOR UPDATE to use with CURRENT OF
Cause: The use of the CURRENT OF cursor_name clause is legal only if cursor_name was declared with a FOR UPDATE clause.
Action: Add a FOR UPDATE clause to the definition of the cursor or do not use the CURRENT OF cursor_name clause.

请先 登录 后评论

1 个回答

小智
PLS-00404:必须使用FOR UPDATE声明游标“ string ”才能与CURRENT OF一起使用,
.原因:只有在使用FOR UPDATE子句声明cursor_name时,使用CURRENT OF cursor_name子句才是合法的。,
.操作:向游标的定义添加一个FOR UPDATE子句,或者不要使用CURRENT OF cursor_name子句。,
.
请先 登录 后评论