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

RMAN-06407: auxiliary instance datafile string deleted

1 Answers  


SQL*Loader-00512: Unable to free read buffer

1 Answers  


NNO-00628: setting maximum reforwards per query to number

1 Answers  


ORA-24193: the property value exceeds the valid range string

1 Answers  


LSX-00281: referenced ID "~S" is not defined

1 Answers  






ORA-29324: SET COMPATIBILITY release string format is wrong

1 Answers  


LPX-00222: error received from SAX callback function

1 Answers  


ORA-12438: repeated policy option: string

1 Answers  


ORA-19643: datafile string: incremental-start SCN is too recent

1 Answers  


TNS-01028: Listener Log File string

1 Answers  


ORA-40219: apply result table string is incompatible with current operation

1 Answers  


NNL-01000: SERVER FAILURE responses received: number

1 Answers  


Categories