PLS-00366: subtype of a NOT NULL type must also be NOT NULL
- 1 Answers
- 2759 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-00074: no process has been specified
ORA-15062: ASM disk is globally closed
ORA-07744: slemcl: invalid error message file handle
RMAN-06426: RECOVERY_CATALOG_OWNER role must be granted to user string
LSX-00204: extra data at end of complex element
RMAN-05001: auxiliary filename string conflicts with a file used by the target database
QSM-02152: subquery or named view in FROM list even after view merging
KUP-04084: The ORACLE_DATAPUMP access driver does not support the ROWID column.
ORA-29276: transfer timeout
NZE-29157: Unable to build an absolute path to the library.
ORA-32632: incorrect subquery in MODEL FOR cell index
ORA-23496: can not change disabled status for "string" and "string"
Oracle Errors 
