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..

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

LPX-00125: duplicate entity "~S" (ignored)

1 Answers  


ORA-19904: test recovery not allowed for datafile string

1 Answers  


RMAN-06009: using target database controlfile instead of recovery catalog

1 Answers   HP,


ORA-09360: Windows 3.1 Two-Task driver unable to allocate context area

1 Answers  


NZE-29035: Pseudo Random Number Generator is needed

1 Answers  






ORA-23619: non-Oracle system error: string

1 Answers  


ORA-27207: syntax error in device PARMS - parentheses mismatch or missing

1 Answers  


ORA-31018: Error deleting XML document

1 Answers  


ORA-27479: Cannot string "string.string" because other objects depend on it

1 Answers  


ORA-00830: cannot set statistics_level to BASIC with auto-tune SGA enabled

1 Answers  


ORA-00070: command string is not valid

1 Answers  


ORA-01690: sort area size too small

1 Answers  


Categories