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-12711: this CREATE CONTROLFILE character set is not allowed

1 Answers  


ORA-01307: no LogMiner session is currently active

1 Answers  


LPX-00402: invalid axisname in the XSL file

1 Answers  


EXP-00040: Dump file and log file must be different

1 Answers  


NNL-00802: Queries received, type ADDRESS: number

1 Answers  


NNL-00517: Insert-replaces a data item under an existing name

1 Answers  


QSM-02040: top level query contains GSets and the key is too long for rewrite

1 Answers  


ORA-08452: specification of E in picture mask is unsupported

1 Answers  


ORA-06761: TLI Driver: error sending orderly release

1 Answers  


ORA-13435: GeoRaster metadata dimension inconsistent

1 Answers  


ORA-25954: missing primary key or unique constraint on dimension

1 Answers  


ORA-32641: invalid expression in MODEL rule ORDER BY clause

1 Answers  


Categories