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-00385: type mismatch found at 'string' in SELECT...INTO
statement



PLS-00385: type mismatch found at 'string' in SELECT...INTO statement..

Answer / guest

Cause: The expressions to the left and right of the INTO
clause in a SELECT...INTO statement 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 ?    2 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

QSM-02054: DISTINCT clause in select list in mv

1 Answers  


RMAN-08523: restoring datafile string to string

1 Answers  


ORA-02036: too many variables to describe with automatic cursor open

1 Answers  


ORA-33278: (DBERR09) Analytic workspace string cannot be attached in RW or EXCLUSIVE mode until the changes made and updated in MULTI mode are committed or rolled back.

1 Answers  


EXP-00099: Table "string"."string" is not in a valid state, table will not be exported

1 Answers  


ORA-02229: invalid SIZE option value

1 Answers  


ORA-08433: invalid picture type in convert raw to number

1 Answers  


ORA-32056: invalid number of extents

1 Answers  


ORA-30354: Query rewrite not allowed on SYS relations

1 Answers  


ORA-14309: Total count of list values exceeds maximum allowed

1 Answers  


ORA-19860: piece validation cannot be performed more than once

1 Answers  


ORA-30175: invalid type given for an argument

1 Answers  


Categories