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-02141: invalid OFFLINE option

1 Answers  


SQL*Loader-00607: partition not empty for INSERT option; table string, partition string

1 Answers  


ORA-00110: invalid value string for attribute string, must be between string and string

1 Answers  


ORA-27102: out of memory

1 Answers  


ORA-33054: (XSAGDNGL26) In AGGMAP workspace object, a MIN argument of number must be less than a FLOOR argument of number.

1 Answers  


ORA-32739: Hang analysis aborted due to failed heap re-grow

1 Answers  


ORA-12832: Could not allocate slaves on all specified instances

1 Answers  


ORA-32059: deadlock detected on mapping structures

1 Answers  


NID-00107: File I/O error on datafile "string" during string operation (number/string)

1 Answers  


KUP-04011: file system is full

1 Answers  


ORA-31191: Resource string is already checked out

1 Answers  


ORA-22933: cannot change object with type or table dependents

1 Answers  


Categories