PLS-00366: subtype of a NOT NULL type must also be NOT NULL
- 1 Answers
- 3041 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-29299: Invalid handle for piecewise compress or uncompress
ORA-16612: string value too long for attribute "string"
ORA-26048: Scoped REF column has wrong table name.
ORA-30728: maximum number of columns exceeded
ORA-10619: Avoid assertions when possible
NZE-28766: failure to terminate use of data source
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
QSM-01004: no query rewrite before view merging
LRM-00105: 'string' is not a legal Boolean for 'string'
PROT-00410: Please ensure you have file creation privileges in the executing directory before running this tool.
RMAN-06540: tablespace string will be excluded from future whole database backups
ORA-01879: the hh25 field must be between 0 and 24
Oracle Errors 
