PLS-00314: TABLE declarations are not allowed as PL/SQL local variables
Cause: In a precompiled program, the DECLARE TABLE statement was mistakenly used inside an embedded PL/SQL block. If an embedded PL/SQL block refers to a database table that does not yet exist, use the DECLARE TABLE statement to tell the precompiler what the table will look like. However, DECLARE TABLE statements are allowed only in the host program.
Action: Move the DECLARE TABLE statement outside the embedded PL/SQL block. If you want a variable that can store an entire row of data selected from a database table or fetched from a cursor or cursor variable, use the %ROWTYPE attribute.
PLS-00315
Custom Search


More Oracle errors
LPX-00314an internal failure occurred
NNF-00540Failed to insert name: string
RMAN-06559MAXSIZE must be larger than 1 kb
ORA-16648a new observer registered with identifier string
QSM-00750the specified value string for parameter string is invalid or contains an invalid item
ORA-29858error occurred in the execution of ODCIINDEXALTER routine
SQL*Loader-00525OCI return status: success
CLSR-00523Resource string is not enabled
ORA-22873primary key not specified for primary key based object table
ORA-19597file string block size string does not match set block size of string
ORA-19665size string in file header does not match actual file size of string
DRG-12246SDATA operand not compatible with the sdata section string
DIA-48492The report component name is not defined
ORA-38722ON or OFF expected.
CLST-02402failure string querying existing configured node list
ORA-31086insufficient privileges to register schema "string"
ORA-37040(XSACQUIRE_DEP_LOCKED) Composite, concat, dimension map, or internal partition workspace object is locked by another user.
ORA-32131bind data type cannot be changed
ORA-32808message system link string does not exist
ORA-07632smsrcx: $DELTVA failure




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-00314TABLE declarations are not allowed as PL/SQL local variables