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-00383: type mismatch found at 'string' inside an IN or
NOT IN clause



PLS-00383: type mismatch found at 'string' inside an IN or NOT IN clause..

Answer / guest

Cause: In a test for set membership such as X NOT IN (SELECT
Y ... ), the expressions X and Y do not match in datatype,
and it is unclear which implicit conversion is required to
correct the mismatch.

Action: Change the expressions so that their datatypes
match. You might want to use datatype conversion functions
in the select list.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

TNS-00041: INTCTL: Navigator already running. Start operation cancelled

1 Answers  


NNL-00908: UNKNOWN TYPE responses sent: number

1 Answers  


NNO-00151: warning: ignoring hint for domain "string", server is authoritative

1 Answers  


PCB-00321: Implicit varchar host variables are an Oracle extension

1 Answers  


EXP-00015: error on row number of table string, column string, datatype number

1 Answers  


ORA-24159: invalid variable definiton

1 Answers  


LFI-00148: %s can be called only on files opened in byte mode

1 Answers  


ORA-09313: slsprom: error prompting user

1 Answers  


ORA-19611: backup piece out of order. Expected string but found string

1 Answers  


ORA-10662: Segment has long columns

1 Answers  


ORA-24352: invalid COBOL display type passed into OCI call

1 Answers  


PCC-02357: Function calls may not be used as host variable expressions

1 Answers  


Categories