PLS-00505: User Defined Types may only be defined as PLSQL Tables or Records
Cause: An attempt was made to define a type other than TABLE or RECORD, but these are the only user- defined types allowed in this release of PL/SQL. For example, the following type definition is illegal: TYPE Byte IS INTEGER(2); -- illegal
Action: Remove the type definition, or revise it to specify a TABLE or RECORD type.
PLS-00506
Custom Search


More Oracle errors
PLS-00730collection element type does not allow modifications
PCC-00016Unable to open a cursor at line number in file string
ORA-29282invalid file ID
PCC-02315cannot evaluate expression as constant
ORA-41623conflicting values for autocommit and duration properties
ORA-47000Factor Type string already defined
OCI-31080type not specified for attribute or element "string"
SQL*Loader-00531OCI return status: still executing
ORA-14131enabled UNIQUE constraint exists on one of the tables
CLSR-00002Oracle error encountered while executing string
ORA-12518TNS:listener could not hand off client connection
SQL*Loader-00970enabled constraint on an XML column not allowed in direct path
ORA-16041Remote File Server fatal error
ORA-47363error deleting Rule string from Rule Set string, string
PGU-41109field name string does not exist in data definition string
ORA-12400invalid argument to facility error handling
RMAN-06800found ineligible base catalog owned by string
RMAN-04004error from recovery catalog database: string
ORA-10659Segment being shrunk is not a lob
ORA-13500SYSAUX DATAFILE clause specified more than once




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-00505User Defined Types may only be defined as PLSQL Tables or Records