Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


PLS-00108: declarative units must be a single variable
declaration



PLS-00108: declarative units must be a single variable declaration..

Answer / guest

Cause: While checking a declarative unit (a top-level
declare block without the BEGIN...END), PL/SQL found that
there was more than one item declared or that the item was
not a variable declaration. A table is a common variable
declaration at the unit level. To define a TABLE, compile a
DECLARE compilation unit, but only one at a time is allowed.

Action: Declare variables in separate declarative units.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

PLS-00652: aggregate functions should have exactly one argument

1 Answers  


RMAN-06578: INCREMENTAL LEVEL > 0 must be specified with FOR RECOVER OF

1 Answers  


ORA-23407: object name string must be shaped like "schema"."object" or "object"

1 Answers  


ORA-22971: invalid datatype for PRIMARY KEY-based object identifier

1 Answers  


KUP-01006: error signalled during parse of access parameters

1 Answers  






ORA-32509: watchpoint was already deleted

1 Answers  


ORA-13408: invalid blockSize storage parameter

1 Answers  


ORA-31080: type not specified for attribute or element "string"

1 Answers  


ORA-03210: DBMS_ADMIN_PACKAGE invalid option specification

1 Answers  


ORA-32607: invalid ITERATE value in MODEL clause

1 Answers  


ORA-25405: transaction status unknown

1 Answers  


ORA-03239: maxextents (string) reached in LOB segment string.string subpartition string

1 Answers  






Categories