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

NZE-29045: Renegotiation request has been refused.

1 Answers  


O2I-00102: Unable to connect to Oracle

1 Answers  


NID-00390: These files must be writable by this utility.

1 Answers  


IMG-02011: 2FF11 - unsupported image format conversion specified

1 Answers  


ORA-13333: invalid LRS measure

1 Answers  






SQL*Loader-00135: Invalid argument for RESUMABLE

1 Answers  


ORA-21614: constraint violation for attribute number [string]

1 Answers  


ORA-12544: TNS:contexts have different wait/test functions

1 Answers  


ORA-07275: unable to send signal to process

1 Answers  


ORA-24364: internal error while padding blanks

1 Answers  


KUP-04061: directory object string specified for LOBFILE column string is not valid

1 Answers  


NID-00001: Illegal command line syntax - parse error = (number)

1 Answers  


Categories