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-27544: Failed to map memory region for export

1 Answers  


ORA-30039: Cannot drop the undo tablespace

1 Answers  


NZE-29027: Error in entropy collection

1 Answers  


ORA-23456: flavor string does not contain "string"

1 Answers  


IMG-00520: invalid value for numberOfBands

1 Answers  






PCB-00603: An EXEC TOOLS MESSAGE host variable is not a character type

1 Answers  


ORA-01204: file number is string rather than string - wrong file

1 Answers  


RMAN-08122: keep attributes for the backup are changed

1 Answers  


ORA-16060: Log file is current

1 Answers  


NID-00421: Change of database name failed during validation - database is intact.

1 Answers  


ORA-08274: Out of memory for environment variable

1 Answers  


PLS-00606: cursor subquery is not supported on client side in this release

1 Answers  


Categories