PLS-00362: invalid cursor return type; 'string' must be a record type

PLS-00362: invalid cursor return type; 'string' must be a record type
Cause: In a cursor specification or REF CURSOR type definition, a non- record type such as NUMBER or TABLE was specified as the return type. This is not allowed. Only the following return types are allowed: %TYPE %ROWTYPE %ROWTYPE %ROWTYTPE
Action: Revise the cursor specification or REF CURSOR type definition so that it specifies one of the above return types.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 19:02

PLS-00362：无效的游标返回类型; ' string '必须是记录类型,
.原因：在光标指定或REF CURSOR类型定义中，非记录类型（如NUMBER或TABLE）被指定为返回类型。这是不允许的。只允许使用以下返回类型：％TYPE ％ROWTYPE ％ROWTYPE ％ROWTYTPE,
.操作：修改光标规范或REF CURSOR类型定义，以便指定上述返回类型之一。,
.

aiaiDBA

13718043309

010-86462881

PLS-00362: invalid cursor return type; 'string' must be a record type

1 个回答

相似问题