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-12439: invalid combination of policy options

1 Answers  


ORA-12451: label not designated as USER or DATA

1 Answers  


ORA-29925: cannot execute string

1 Answers  


DRG-12003: Please enter username for this FTP server:

1 Answers  


ORA-32639: Aggregate functions on reference MODELs are not allowed

1 Answers  


LPX-00121: undefined notation "~S"

1 Answers  


ORA-09285: sllfop: unrecognizable processing option, incorrect format

1 Answers  


IMG-00545: invalid cut values specified

1 Answers  


KUP-04012: file length is too large for output field

1 Answers  


ORA-16214: apply stalled for apply delay

1 Answers  


ORA-14121: MODIFY DEFAULT ATTRIBUTES may not be combined with other operations

1 Answers  


ORA-33454: (ESDREAD07) Discarding compiled code for workspace object because number is now string workspace object, whereas it was string workspace object when the code was compiled.

1 Answers  


Categories