PLS-00360: cursor declaration without body needs return type

PLS-00360: cursor declaration without body needs return type
Cause: A cursor declaration lacks either a body (SELECT statement) or a return type. If you want to separate a cursor specification from its body, a return type must be supplied, as in CURSOR c1 RETURN emp%ROWTYPE;
Action: Add a SELECT statement or return type to the cursor declaration.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 19:02

PLS-00360：光标声明不需要返回类型,
.原因：游标声明缺少一个主体（SELECT语句）或返回类型。如果要将光标规范与其正文分开，必须提供返回类型，如CURSOR c1 RETURN emp％ROWTYPE;,
.操作：向游标声明添加SELECT语句或返回类型。,
.

aiaiDBA

13718043309

010-86462881

PLS-00360: cursor declaration without body needs return type

1 个回答

相似问题