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

NNL-00512: Shows or sets the server's auto-refresh expiration period

1 Answers  


ORA-22923: amount of data specified in streaming LOB write is 0

1 Answers  


ORA-07684: sou2os: supervisor stack reset error

1 Answers  


ORA-36706: (XSRELTBL07) workspace object should be dimensioned by workspace object and one level dimension.

1 Answers  


TNS-01033: Listener Parameter File string

1 Answers  






ORA-01624: log string needed for crash recovery of instance string (thread string)

1 Answers  


ORA-10914: invalid TABLESPACE GROUP clause

1 Answers  


DRG-11845: No Partial Update

1 Answers  


ORA-39303: schema sync/swap operation fail because of confilcts

1 Answers  


RMAN-06007: target database not mounted and db_name not set in init.ora

1 Answers  


QSM-01116: window function computability checks failed

1 Answers  


ORA-30089: missing or invalid <datetime field>

1 Answers  


Categories