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

TNS-00102: Keyword-Value binding operation error

1 Answers  


ORA-19624: operation failed, retry possible

2 Answers  


ORA-01289: cannot add duplicate logfile string

1 Answers  


ORA-10919: Default temporary tablespace group must have at least one tablespace

1 Answers  


LSX-00134: attribute "~1S" has invalid qualification "~2S"

1 Answers  






ORA-36982: (XSRELGID03) The grouping variable/relation workspace object must be dimensioned by all dimensions of the source relation workspace object which have more than one element in status.

1 Answers  


LFI-01514: ftell() failed in string

1 Answers  


ORA-23426: deferred RPC queue has entries for string

1 Answers  


ORA-19673: error during proxy copy of file string

1 Answers  


ORA-13037: SRIDs do not match for the two geometries

1 Answers  


NNL-00987: Authoritative answers when authority: number

1 Answers  


ORA-36993: (XSRELGID10) OBJECT workspace object must be a VARIABLE, RELATION, or a numeric SURROGATE DIMENSION based on the level dimension workspace object.

1 Answers  


Categories