Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

ORA-01175: data dictionary has more than the string files allowed by the instance

1 Answers  


ORA-13114: [string]_NODE$ table does not exist

1 Answers  


ORA-27060: could not set close-on-exec bit on file

1 Answers  


ORA-22344: can not specify CONVERT TO SUBSTITUTABLE option for ALTER TYPE other than NOT FINAL change

1 Answers  


ORA-29830: operator does not exist

1 Answers  


ORA-27193: sbtinfo2 did not return volume label

1 Answers  


NNL-00536: set|show requests_enabled [<on|off>] [<server_list>] : enable, disable or show server request processing

1 Answers  


ORA-39016: Operation not supported when job is in string state.

1 Answers  


ORA-02028: fetching an exact number of rows is not supported by the server

1 Answers  


ORA-00478: SMON process terminated due to error string

1 Answers  


ORA-13516: SWRF Operation failed: string

1 Answers  


ORA-12047: PCT FAST REFRESH cannot be used for materialized view "string"."string"

1 Answers  


Categories