Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


PLS-00397: Type mismatch in arguments to IN



PLS-00397: Type mismatch in arguments to IN..

Answer / guest

Cause: In a test for set membership such as X IN (Y, Z), the
expressions X, Y, and Z 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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-13127: failed to generate target partition

1 Answers  


TNS-01153: Failed to process string: string

1 Answers  


ORA-10643: Database should be mounted in restricted mode and Exclusive mode

1 Answers  


PLS-01905: : character string buffer too small

1 Answers  


RMAN-06103: duplicate qualifier found in REPORT command: string

1 Answers  






NCR-01013: NCRS: Unvalid connection type.

1 Answers  


ORA-12443: policy not applied to some tables in schema

1 Answers  


PLS-00417: unable to resolve "string" as a column

1 Answers  


ORA-27545: Fail to prepare buffer for remote update

1 Answers  


ORA-03289: partition name and segment type do not match

1 Answers  


PCC-02100: Unable to initialize PL/SQL

1 Answers  


ORA-14617: cannot add/drop values to DEFAULT subpartition

1 Answers  






Categories