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-13710: Parameter "string" must have a higher value than parameter "string". The values supplied were "string" and "string" respectively.
ORA-13751: "SQL Tuning Set" "string" does not exist or user "string" is not the owner of the "SQL Tuning Set".
ORA-14074: partition bound must collate higher than that of the last partition
NNL-00871: Updates refused, name is a topology name: number
DRG-50951: Unable to resolve element name for attribute string
ORA-03231: the INITIAL extent may not be deallocated
DRG-12500: stoplist string already exists
ORA-01180: can not create datafile 1
NZE-29030: SSL handshake is requested.
ORA-13282: failure on initialization of coordinate transformation
ORA-30076: invalid extract field for extract source
ORA-16752: Resource guard could not mount standby