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-00581: inheritance is not supported for opaque types

1 Answers  


ORA-16170: Terminal recovery may have left the database in an inconsistent state

1 Answers  


RMAN-03037: Spooling started in log file: string

1 Answers  


DRG-11221: Third-party filter indicates this document is corrupted.

1 Answers  


ORA-09769: osnmbr: cannot send break message

1 Answers  






UDI-00017: Data Pump job is already executing.

1 Answers  


NNL-00950: Cache lookup requests: number

1 Answers  


ORA-16064: remote archival is disabled by another instance

1 Answers  


DRG-10705: invalid value string for attribute string

1 Answers  


ORA-39082: Object type string created with compilation warnings

1 Answers  


ORA-27454: argument name and position cannot be NULL

1 Answers  


NZE-28844: No wallet present

1 Answers  


Categories