Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


PLS-00366: subtype of a NOT NULL type must also be NOT NULL



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

Post New Answer

More Oracle Errors Interview Questions

NNO-00801: Error: OCI_SUCCESS_WITH_INFO: string

1 Answers  


RMAN-06174: not connected to auxiliary database

1 Answers  


ORA-12225: TNS:destination host unreachable

1 Answers  


ORA-12233: TNS:Failure to accept a connection

1 Answers  


ORA-24100: error in ktz testing layer

1 Answers  






QSM-02057: ROWNUM referenced in mv

1 Answers  


PLS-00662: Non-external object types containing external mapped attributes are not allowed

1 Answers  


ORA-39019: invalid operation type string

1 Answers  


ORA-02290: check constraint (string.string) violated

1 Answers  


EXP-00076: multiple devices specified for tape output

1 Answers  


SQL*Loader-00939: OCI error while string for table string partition string

1 Answers  


TNS-04209: Trace Assistant Internal ERROR: Type Error

1 Answers  






Categories