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


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-16095: Dependent destination removal for inactivation

1 Answers  


ORA-14646: Specified alter table operation involving compression cannot be performed in the presence of usable bitmap indexes

1 Answers  


ORA-24149: invalid rule name

1 Answers  


ORA-24131: table string has incorrect columns

1 Answers  


KUP-04055: column string is both a field in the data file and a column transform

1 Answers  






ORA-09330: Session terminated internally by Oracle or by an Oracle DBA

1 Answers  


NNC-00401: program interface initialization failed

1 Answers  


ORA-14104: RECOVERABLE/UNRECOVERABLE may not be specified for partitioned tables/indices

1 Answers  


NZE-29118: Cannot create PKCS #12 attributes.

1 Answers  


PCC-00063: Reached end of file string before End-of-Statement at line number!

1 Answers  


ORA-30682: improper value for argument OPTION_FLAGS

1 Answers  


ORA-26024: SKIP_UNUSABLE_INDEXES requested and index segment was initially unusable

0 Answers  






Categories