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

PLS-00363: expression 'string' cannot be used as an assignment target

1 Answers  


ORA-39124: dump file name "string" contains an invalid substitution variable

1 Answers  


IMP-00068: Could not find environment national character set

1 Answers  


LFI-00107: Open does not expect the file [string][string] to exist.

1 Answers  


PLS-01409: Use of 'PRIOR_' token

1 Answers  


ORA-39013: All of the workers exited before the job completed.

1 Answers  


ORA-30336: no child for specified JOIN KEY

1 Answers  


ORA-40209: setting % is invalid for % function

1 Answers  


ORA-07246: sfofi: open error, unable to open database file.

1 Answers  


ORA-19726: cannot plug data [string] at level string into database running at compatibility level string

1 Answers  


ORA-22858: invalid alteration of datatype

1 Answers  


ORA-04015: ascending sequences that CYCLE must specify MAXVALUE

1 Answers  


Categories