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-12711: this CREATE CONTROLFILE character set is not allowed
ORA-01307: no LogMiner session is currently active
LPX-00402: invalid axisname in the XSL file
EXP-00040: Dump file and log file must be different
NNL-00802: Queries received, type ADDRESS: number
NNL-00517: Insert-replaces a data item under an existing name
QSM-02040: top level query contains GSets and the key is too long for rewrite
ORA-08452: specification of E in picture mask is unsupported
ORA-06761: TLI Driver: error sending orderly release
ORA-13435: GeoRaster metadata dimension inconsistent
ORA-25954: missing primary key or unique constraint on dimension
ORA-32641: invalid expression in MODEL rule ORDER BY clause