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-13710: Parameter "string" must have a higher value than parameter "string". The values supplied were "string" and "string" respectively.

1 Answers  


ORA-13751: "SQL Tuning Set" "string" does not exist or user "string" is not the owner of the "SQL Tuning Set".

1 Answers  


ORA-14074: partition bound must collate higher than that of the last partition

1 Answers  


NNL-00871: Updates refused, name is a topology name: number

1 Answers  


DRG-50951: Unable to resolve element name for attribute string

1 Answers  


ORA-03231: the INITIAL extent may not be deallocated

1 Answers  


DRG-12500: stoplist string already exists

1 Answers  


ORA-01180: can not create datafile 1

1 Answers  


NZE-29030: SSL handshake is requested.

1 Answers  


ORA-13282: failure on initialization of coordinate transformation

1 Answers  


ORA-30076: invalid extract field for extract source

1 Answers  


ORA-16752: Resource guard could not mount standby

1 Answers  


Categories