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
NNL-00008request not understood by server
PCB-00701MAX OCCURRANCES must be between 1 and 65535
NNL-01001NAME EXISTS responses received: number
ORA-02800Requests timed out
PCC-02022Found end of file while scanning a SQL statement
ORA-01336specified dictionary file cannot be opened
NNC-00500warning: "string" parameter value is illegal, setting to string
QSM-01218query rewrite is likely more expensive due to a single table match between materialized view and query
ORA-14320DEFAULT cannot be specified for ADD/DROP VALUES or SPLIT
RMAN-03042error while analyzing automatic repair options
ORA-31644unable to position to block number string in dump file "string"
ORA-03125client-server protocol violation
PLS-01467The value list of the IN predicate, if not a subquery, must contain only value_specifications
ORA-23537function or procedure string is not allowed to be invoked from this site.
ORA-39023Version string is not supported.
ORA-40024solution to least squares problem could not be found
NZE-29007Bad Clear Key Length when using SSL 2.0
ORA-30179invalid argument index used in a format code
ORA-14054invalid ALTER TABLE TRUNCATE PARTITION option
ORA-37108(XSVPART08) workspace object has an AGGCOUNT, but workspace object does not.




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