PLS-00320: the declaration of the type of this expression is incomplete or malformed

PLS-00320: the declaration of the type of this expression is incomplete or malformed
Cause: In a declaration, the name of a variable or cursor is misspelled or the declaration makes a forward reference. Forward references are not allowed in PL/SQL. A variable or cursor must be declared before it is referenced it in other statements, including other declarative statements. For example, the following declaration of dept_rec raises this exception because it refers to a cursor not yet declared: DECLARE dept_rec dept_cur%ROWTYPE; CURSOR dept_cur IS SELECT ... ...
Action: Check the spelling of all identifiers in the declaration. If necessary, move the declaration so that it makes no forward references.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 19:02

PLS-00320：此表达式的类型的声明不完整或格式错误,
.原因：在声明中，变量或游标的名称拼写错误，或声明作为前向引用。PL / SQL中不允许转发引用。必须声明变量或游标，然后才能在其他语句中引用它，包括其他声明性语句。例如，dept_rec的以下声明引发了此异常，因为它引用了尚未声明的游标：DECLARE dept_rec dept_cur％ROWTYPE; CURSOR dept_cur IS SELECT ... ...,
.操作：检查声明中所有标识符的拼写。如有必要，请移动声明，使其不作参考。,
.

aiaiDBA

13718043309

010-86462881

PLS-00320: the declaration of the type of this expression is incomplete or malformed

1 个回答

相似问题