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

EXP-00062: invalid source statements for an object type

1 Answers  


LSX-00164: no content specified in "~S"

1 Answers  


NID-00410: Reversion of database changes failed during validation - database is intact.

1 Answers  


IMG-00924: Incorrect parameter specification during CREATE INDEX

1 Answers  


IMG-00554: extra value in rotate operation

1 Answers  


ORA-23378: connection qualifier "string" is not valid for object group "string"."string"

1 Answers  


ORA-29503: SCHEMA keyword not valid with NAMED keyword

1 Answers  


ORA-00029: session is not a user session

1 Answers  


ORA-01089: immediate shutdown in progress - no operations are permitted

1 Answers  


ORA-08002: sequence string.CURRVAL is not yet defined in this session

1 Answers  


UDE-00011: parameter string is incompatible with parameter string

1 Answers  


NNL-00902: ALIAS LOOP responses sent: number

1 Answers  


Categories