PLS-00366: subtype of a NOT NULL type must also be NOT NULL
- 1 Answers
- 2920 Views
- I also Faced
- E-Mail Answers
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-13194: failed to decode supercell
ORA-07470: snclget: cannot get cluster number.
ORA-12008: error in materialized view refresh path
ORA-19624: operation failed, retry possible
ORA-19512: file search failed
ORA-12556: TNS:no caller
ORA-16042: user requested cancel immediate of managed recovery operation
ORA-02700: osnoraenv: error translating ORACLE_SID
ORA-07573: slkhst: could not perform host operation
ORA-17611: ksfd: file 'string' cannot be accessed, global open closed
NZE-29194: no CRL found in cache
PLS-00526: A MAP or ORDER function is required for comparing objects in PL/SQL.
Oracle Errors 
