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-04094: table string.string is constraining, trigger may not modify it

1 Answers  


ORA-02249: missing or invalid value for MAXLOGMEMBERS

1 Answers  


PLS-01425: Connect-by clause

1 Answers  


ORA-02831: Segment deallocation failed - empty segment list

1 Answers  


QSM-01126: query rewritten with set operator materialized view, string

1 Answers  


ORA-14049: invalid ALTER TABLE MODIFY PARTITION option

1 Answers  


O2F-00307: Unable to read the INTYPE file

1 Answers  


ORA-31653: unable to determine job operation for privilege check

1 Answers  


RMAN-06525: RMAN retention policy is set to none

1 Answers  


ORA-13150: failed to insert exception record

1 Answers  


ORA-09741: spwat: error waiting for a post.

1 Answers  


ORA-06794: TLI Driver: shadow process could not retrieve protocol info

1 Answers  


Categories