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-16235: DDL skipped because import has occurred
ORA-03284: datafile string is not a member of tablespace string
SQL*Loader-00556: unable to allocate read buffer
ORA-01178: file string created before last CREATE CONTROLFILE, cannot recreate
ORA-27472: invalid metadata attribute string
ORA-38435: missing elementary attribute value or invalid name-value pairs
ORA-36268: (XSCGMDLAGG01) 'string' is not a valid dimension value.
NZE-29015: incorrect message length
ORA-38419: invalid identifier in attribute : string
TNS-12683: encryption/crypto-checksumming: no Diffie-Hellman seed
ORA-12554: TNS:current operation is still in progress
ORA-24095: invalid transformation, source type does not match that of the queue