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 |
EXP-00062: invalid source statements for an object type
LSX-00164: no content specified in "~S"
NID-00410: Reversion of database changes failed during validation - database is intact.
IMG-00924: Incorrect parameter specification during CREATE INDEX
IMG-00554: extra value in rotate operation
ORA-23378: connection qualifier "string" is not valid for object group "string"."string"
ORA-29503: SCHEMA keyword not valid with NAMED keyword
ORA-00029: session is not a user session
ORA-01089: immediate shutdown in progress - no operations are permitted
ORA-08002: sequence string.CURRVAL is not yet defined in this session
UDE-00011: parameter string is incompatible with parameter string
NNL-00902: ALIAS LOOP responses sent: number