PLS-00108: declarative units must be a single variable declaration
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.
PLS-00111
Custom Search


More Oracle errors
ORA-33274(DBERR07) Timed out while trying to lock analytic workspace string for string.
QSM-02064subquery in mv
LFI-00148string can be called only on files opened in byte mode
AMD-00114PROCEDURE string, internal error
ORA-01142cannot end online backup - none of the files are in backup
ORA-39175Encryption password is not needed.
ORA-13799threshold not found
DRG-51202invalid key mapping operation mode : string
ORA-23421job number string is not a job in the job queue
ORA-12682Login failed: the SecurID card is in next PRN mode
RMAN-06501skipping datafile string; already backed up on string
ORA-41300File driver is not initialized
QSM-00759the user string does not exist for the specified workload statement
NZE-28806Cannot write to the data source.
DIA-48436File [string] does not exist
ORA-32848foreign queue DOMAIN required for JMS unified connections
PGA-21046logging switched to system log due to error on log file
ORA-41662number of primitive events in the composite event exceeds maximum limit
ORA-01002fetch out of sequence
DRG-11863Bad, Incomplete, Or Unknown Response




TOP 20 Oracle errors
ORA-12504TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
RMAN-20079full resync from primary database is not done
ORA-14411The DDL cannot be run concurrently with other DDLs
ORA-14760ADD PARTITION is not permitted on Interval partitioned objects
ORA-10877error signaled in parallel recovery slave string
ORA-32701Hang detected
ORA-00838Specified value of MEMORY_TARGET is too small, needs to be at least stringM
ORA-16665timeout waiting for the result from a database
ORA-16957SQL Analyze time limit interrupt
ORA-16664unable to receive the result from a database
RMAN-08132WARNING: cannot update recovery area reclaimable file list
ORA-00000normal, successful completion
ORA-16766Redo Apply is stopped
ORA-00837Specified value of MEMORY_TARGET greater than MEMORY_MAX_TARGET
RMAN-08137WARNING: archived log not deleted as it is still needed
DIA-48122error with opening the ADR block file [string] [string]
ORA-47988password should contain at least one numeric and one alphabetic character
IMP-00057Warning: Dump file may not contain data of all partitions of this table
ORA-00001unique constraint (string.string) violated
ORA-55508Invalid input to Flashback Transaction Backout




Your own TOP 20 Oracle errors
PLS-00108declarative units must be a single variable declaration