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-24034: application string is already a subscriber for queue string

1 Answers  


IMG-02005: 2FF05 - incorrect color specification

1 Answers  


ORA-39017: Worker request not supported when job is in string state.

1 Answers  


TNS-12160: TNS:internal error: Bad error number

1 Answers  


ORA-02021: DDL operations are not allowed on a remote database

1 Answers  






ORA-13385: error in network manager: [string]

1 Answers  


LFI-00116: Unable to close file in operation string.

1 Answers  


ORA-02464: Cluster definition can not be both HASH and INDEX

1 Answers  


ORA-16098: inaccessible standby database forced shutdown to protect primary

1 Answers  


ORA-39107: Master process string violated startup protocol. Master error:

1 Answers  


ORA-27203: skgfpqb: sbtpcquerybackup returned error

1 Answers  


ORA-19763: compatibility version string is higher than maximum allowed: string

1 Answers  


Categories