PLS-00366: subtype of a NOT NULL type must also be NOT NULL
- 1 Answers
- 2758 Views
- I also Faced
- E-Mail Answers
Answer / guest
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.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
ORA-39080: failed to create queues "string" and "string" for Data Pump job
PCC-02330: expecting an expression of integer type
NCR-03019: NCRO: Unable to initialize thread support
LPX-00316: invalid value ~S for ~S attribute ~S
ORA-09342: Detached process terminated by Oracle during shutdown abort
SQL*Loader-00291: Invalid bind variable string in SQL string for column string.
ORA-12730: invalid equivalence class in regular expression
NNO-00267: warning: configuration database contains no data for server "string"
ORA-14521: Default tablespace string block size [string] for string string does not match existing string block size [string]
NNO-00609: warning: forwarder number address length number exceeds maximum of number, ignored
ORA-16754: Resource guard could not activate standby
QSM-02114: no GROUP BY clause, no aggregates and not >= 9.0 compatibility
Oracle Errors 
