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

PCB-00201: Indicator variable string not a group item

1 Answers  


ORA-29928: duplicate default selectivity specified

1 Answers  


NNL-00814: Total query processing time: string

1 Answers  


TNS-12560: TNS:protocol adapter error

1 Answers  


PLS-01506: CREATE INDEX is non-ANSI

1 Answers  


ORA-32737: Hang analysis aborted due to failed memory allocation

1 Answers  


ORA-09875: TASDEF_WRITE: write error when writing ?/dbs/tasdef@.dbf file.

1 Answers  


RMAN-20241: ambiguous archived log name

1 Answers  


ORA-04003: sequence parameter string exceeds maximum size allowed (string digits)

1 Answers  


DRG-11819: Bad Request

1 Answers  


ORA-30153: An invalid File Object is passed to the OCIFile function

1 Answers  


ORA-07576: sspexst: $GETJPIW failure on process ID string

1 Answers  


Categories