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-08236smsget: cannot share subcube with listener
ORA-13031Invalid Gtype in the SDO_GEOMETRY object for point object
LPX-00701invalid SOAP role
ORA-41647negation not allowed in rule conditions with "any" semantics
ORA-32730Command cannot be executed on remote instance
TNS-02526server proxy type does not match client type
RMAN-06290Report of database schema for database with db_unique_name string
ORA-12092cannot online redefine replicated table "string"."string"
DRG-11446supplied knowledge base file string not installed
ORA-04045errors during recompilation/revalidation of string.string
ORA-00073command string takes between string and string argument(s)
EVM-00105Missing end-of-group character
ORA-12915Cannot alter dictionary managed tablespace to read write
ORA-27208syntax error in device PARMS - environment variable value missing
ORA-44815User name is too large
ORA-31139Invalid resource configuration list
ORA-13467unsupported GeoRaster metadata specification: string
TNS-01170Event detection broke for address: string
SQL*Loader-00412More columns specified for table string than the maximum (number)
ORA-15180could not open dynamic library string, error [string]




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
ORA-00000normal, successful completion
RMAN-08132WARNING: cannot update recovery area reclaimable file list
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