PLS-00383: type mismatch found at 'string' inside an IN or
NOT IN clause



PLS-00383: type mismatch found at 'string' inside an IN or NOT IN clause..

Answer / guest

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

Post New Answer

More Oracle Errors Interview Questions

ORA-00166: remote/local nesting level is too deep

1 Answers  


DRG-10103: illegal value for argument: string

1 Answers  


ORA-12154: TNS:could not resolve the connect identifier specified

1 Answers  


ORA-15055: unable to connect to ASM instance

1 Answers  


ORA-38747: corrupt before image (file# string, block# string)

1 Answers  






ORA-12430: invalid privilege number

1 Answers  


NNO-00609: warning: forwarder number address length number exceeds maximum of number, ignored

1 Answers  


ORA-14124: duplicate REVERSE clause

1 Answers  


ORA-15068: maximum number of diskgroups string already mounted

1 Answers  


IMP-00033: Warning: Table "string" not found in export file

2 Answers  


ORA-28501: communication error on heterogeneous database link

1 Answers  


ORA-16577: corruption detected in Data Guard configuration file

1 Answers  


Categories