Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

ORA-00376: file string cannot be read at this time

1 Answers  


ORA-01039: insufficient privileges on underlying objects of the view

1 Answers  


ORA-30936: Maximum number (string) of 'string' XML node elements exceeded

1 Answers  


EXP-00025: dictionary shows no column for constraint string.number

1 Answers  


ORA-26000: partition load specified but table string is not partitioned

1 Answers  






ORA-24076: cannot perform operation string for NON_PERSISTENT queue string.string

1 Answers  


ORA-13774: insufficient privileges to select data from the workload repository

1 Answers  


ORA-32625: illegal dimension in cell reference predicate

1 Answers  


ORA-24770: cannot forget a prepared transaction

1 Answers  


NZE-28853: Initialization failure

1 Answers  


ORA-13241: specified dimensionality does not match that of the data

1 Answers  


ORA-16717: clearing parameter LOG_ARCHIVE_DUPLEX_DEST failed

1 Answers  






Categories