PLS-00366: subtype of a NOT NULL type must also be NOT NULL
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-24382: statement handled already executed or described
RMAN-06740: database name is not specified
ORA-02034: speed bind not permitted
PLS-00355: use of pl/sql table not allowed in this context
DRG-50946: Invalid unary operator for theme index
ORA-33452: (ESDREAD06) Discarding compiled code for workspace object because number is now dimensioned by workspace object. It was dimensioned by workspace object when the code was compiled.
ORA-16777: unable to find the destination entry of a standby in V$ARCHIVE_DEST
ORA-36683: (XSDPART21) Partition string dimensioned by more than one composite.
EXP-00040: Dump file and log file must be different
PCB-00240: Group item containing this host variable cannot be table
ORA-02042: too many distributed transactions
ORA-06309: IPA: No message queue available