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-36674: (XSDPART12) Invalid dimension value starting at string.

1 Answers  


ORA-13278: failure to convert SRID to native format

1 Answers  


DRG-11526: filename exceeds maximum length

1 Answers  


ORA-00439: feature not enabled: string

1 Answers  


NPL-00419: received ASN.1 object identifier with sub-identifier that is too large

1 Answers  


ORA-13364: layer dimensionality does not match geometry dimensions

1 Answers  


ORA-00231: snapshot controlfile has not been named

1 Answers  


ORA-02257: maximum number of columns exceeded

1 Answers  


ORA-00474: SMON process terminated with error

1 Answers  


ORA-06033: NETDNT: connect failed, partner rejected connection

1 Answers  


ORA-16120: dependencies being computed for transaction at SCN string

1 Answers  


ORA-21561: OID generation failed

1 Answers  


Categories