PLS-00366: subtype of a NOT NULL type must also be NOT NULL
Cause: After a subtype was defined as NOT NULL, it was used as the base type for another subtype defined as NULL. That is not allowed. For example, the code might look like DECLARE SUBTYPE Weekday IS INTEGER NOT NULL; SUBTYPE Weekend IS Weekday NULL; -- illegal instead of DECLARE SUBTYPE Weekday IS INTEGER NOT NULL; SUBTYPE Weekend IS Weekday;
Action: Revise the subtype definitions to eliminate the conflict.
PLS-00367
Custom Search


More Oracle errors
ORA-01323Invalid state
ORA-24204existing string propagation schedules
ORA-19618cannot name files after RESTOREVALIDATE has been called
ORA-07251spcre: semget error, could not allocate any semaphores.
RMAN-06193connected to target database (not started)
ORA-08005specified row does not exist
NNL-00568delegate_domain <domain_name> <NS_name> <NS_Addr> : Delegate the given domain to the given nameserver
ORA-28651Primary index on IOTs can not be marked unusable
ORA-42302definition of an Editioning view may not refer to remote tables
ORA-03001unimplemented feature
ORA-16236Logical Standby metadata operation in progress
ORA-28040No matching authentication protocol
ORA-38102Invalid column in the INSERT WHERE Clause: string
ORA-12449Labels specified for user must be of type USER
ORA-25153Temporary Tablespace is Empty
EXP-00036Object number non-existent in dictionary
ORA-39097Data Pump job encountered unexpected error string
ORA-33092(XSAGCOMP04) number is not the name of a MODEL in any attached analytic workspace.
ORA-19261XQDY0041 - non empty URI in QName
DRG-11733more than one translation for the term in the specified language




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-00366subtype of a NOT NULL type must also be NOT NULL