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-16235: DDL skipped because import has occurred

1 Answers  


ORA-03284: datafile string is not a member of tablespace string

1 Answers  


SQL*Loader-00556: unable to allocate read buffer

1 Answers  


ORA-01178: file string created before last CREATE CONTROLFILE, cannot recreate

1 Answers  


ORA-27472: invalid metadata attribute string

1 Answers  


ORA-38435: missing elementary attribute value or invalid name-value pairs

1 Answers  


ORA-36268: (XSCGMDLAGG01) 'string' is not a valid dimension value.

1 Answers  


NZE-29015: incorrect message length

1 Answers  


ORA-38419: invalid identifier in attribute : string

1 Answers  


TNS-12683: encryption/crypto-checksumming: no Diffie-Hellman seed

1 Answers  


ORA-12554: TNS:current operation is still in progress

1 Answers  


ORA-24095: invalid transformation, source type does not match that of the queue

1 Answers  


Categories