PLS-00507: a PLSQL Table may not contain a table or a record with composite fields
Cause: In a TABLE type definition, a nested record type was specified as the element type. This is not allowed. All fields in the record must be scalars.
Action: Remove the TABLE type definition, or replace the nested record type with a simple record type.
PLS-00508
Custom Search


More Oracle errors
LPX-01080[XQST0080] Invalid target type
PCB-00306CREATE FUNCTION/PROCEDURE/PACKAGE/TRIGGER are Oracle extensions
PCC-02337cannot declare multi-dimensioned array for this type
QSM-01213query rewrite not possible when nested aggregates or CONNECT BY/START WITH clause is present
NNO-00634received authoritative name "string" when we are its authority
PCB-00236Cannot use PIC N/G variable. NLS_NCHAR not set or set incorrectly.
ORA-47021Factor string not found
ORA-12162TNS:net service name is incorrectly specified
ORA-36833(XSLMGEN03) View token cannot be blank
ORA-24850failed to startup shared subsystem
NID-00371Change database name of database string to string? (Y/[N]) =>
ORA-15130diskgroup "string" is being dismounted
KUP-00600internal error, arguments [string] [string] [string] [string] [string]
ORA-13610The directive string does not exist for task string.
RMAN-06407auxiliary instance file string deleted
ORA-30341dropped level has references
LSX-00234invalid decimal "~S"
TNS-00511No listener
ORA-25527bad format of _DB_MTTR_SIM_TARGET
ORA-31691The worker received message number string from the MCP, which is invalid.




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-00507a PLSQL Table may not contain a table or a record with composite fields