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

ORA-22065: number to text translation for the given format causes overflow

1 Answers  


ORA-24413: Invalid number of sessions specified

1 Answers  


ORA-02329: column of datatype string cannot be unique or a primary key

1 Answers  


ORA-23394: duplicate propagator

1 Answers  


ORA-30771: Cannot add more than one referential constraint on REF column "string"

1 Answers  






NZE-29106: Cannot import PKCS #12 wallet.

1 Answers  


PLS-00354: username must be a simple identifier

1 Answers  


PCB-00234: FOR variable "string" is invalid type

1 Answers  


NMP-00005: general SNMP error

1 Answers  


DRG-52101: an invalid session handle was passed to Oracle Text

1 Answers  


ORA-32404: snapshot log uses Change Data Capture which is not enabled for this database

1 Answers  


ORA-13295: geometry objects are in different coordinate systems

1 Answers  


Categories