PLS-00366: subtype of a NOT NULL type must also be NOT NULL
- 1 Answers
- 2784 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 |
DRG-11709: too many terms in thesaurus
ORA-12097: changes in the master tables during refresh, try refresh again
ORA-07245: sfccf: unable to lseek and write the last block.
NCR-03024: NCRO: Transport type LIST not supported
SQL*Loader-00259: Could not escalate DDL share lock to exclusive on table string
ORA-01548: active rollback segment 'string' found, terminate dropping tablespace
ORA-01269: Destination parameter string is too long
ORA-23534: missing column in materialized view container table "string"."string"
ORA-03282: missing ALLOCATE EXTENT option
ORA-01293: mounted database required for specified LogMiner options
ORA-38493: feature not enabled : Expression Filter index
ORA-16608: one or more sites have warnings
Oracle Errors 
