PLS-00642: local collection types not allowed in SQL statements
Cause: A locally-defined (i.e. not schema level) collection type was used in a SQL statement. The type must be defined in a schema to be accepted in a SQL statement.
Action: Define the collection type in your schema, not inside a PL/SQL subprogram.
PLS-00643
Custom Search


More Oracle errors
ORA-26029index string.string partition string initially in unusable state
ORA-24399invalid number of connections specified
ORA-13609The specified task string must be executing to be cancelled or interrupted.
ORA-15098file type not recognized by ASM instance
QSM-01113HAVING clause of mv, string, is more restrictive than query
OCI-19203Error occurred in DBMS_XMLGEN processingstring
QSM-03117Cannot tune the materialized view to be fast refreshable
ORA-12010cannot create materialized view log on table owned by SYS
ORA-09956scgcm: unexpected lock status condition
ORA-13785missing target object for tuning task "string"
DIA-48462Fatal error encountered in [string]
ORA-21501program could not allocate memory
QSM-01031materialized view, string, is stale in TRUSTED integrity mode
ORA-16760cannot start SQL Apply
DIA-48215Sequence Invalid Operation [string] [string]
OCI-30130invalid parameter key type received
ORA-36714(XSMXALLOC03) TARGETLOG variable workspace object must have the same data type as TARGET variable workspace object.
DIA-49428No such directory or directory not accessible [string]
ORA-36974(XSRELTBL14) workspace object is not a BOOLEAN variable dimensioned by all the dimensions of the hierarchy.
LPX-00772wrong object type




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-00642local collection types not allowed in SQL statements