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-01175: data dictionary has more than the string files allowed by the instance
ORA-13114: [string]_NODE$ table does not exist
ORA-27060: could not set close-on-exec bit on file
ORA-22344: can not specify CONVERT TO SUBSTITUTABLE option for ALTER TYPE other than NOT FINAL change
ORA-29830: operator does not exist
ORA-27193: sbtinfo2 did not return volume label
NNL-00536: set|show requests_enabled [<on|off>] [<server_list>] : enable, disable or show server request processing
ORA-39016: Operation not supported when job is in string state.
ORA-02028: fetching an exact number of rows is not supported by the server
ORA-00478: SMON process terminated due to error string
ORA-13516: SWRF Operation failed: string
ORA-12047: PCT FAST REFRESH cannot be used for materialized view "string"."string"