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-12087: online redefinition not allowed on tables owned by "string"

1 Answers  


ORA-28526: invalid describe information returned to Heterogeneous Services

1 Answers  


PLS-00583: size must be specified if opaque type is fixed-length

1 Answers  


ORA-22342: dependent VARRAY column exceeds the maximum inline column size

1 Answers  


ORA-02058: no prepared transaction found with ID string

1 Answers  






ORA-38304: missing or invalid user name

1 Answers  


ORA-12345: user string lacks CREATE SESSION privilege in database link (linkname string)

1 Answers  


ORA-14030: non-existent partitioning column in CREATE TABLE statement

1 Answers  


ORA-23342: invalid parameter column string

1 Answers  


ORA-01946: DEFAULT TABLESPACE already specified

1 Answers  


SQL-02144: Invalid ANSI dynamic usage

1 Answers  


ORA-06790: TLI Driver: poll failed

1 Answers  


Categories