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-15110: no diskgroups mounted

1 Answers  


ORA-00280: change string for thread string is in sequence #string

1 Answers  


PROT-00007: Failed to open the specified import file

1 Answers  


RMAN-08532: channel string: restoring block(s) from datafilecopy string

1 Answers  


ORA-39726: unsupported add/drop column operation on compressed tables

1 Answers  






ORA-09354: Windows 32-bit Two-Task driver: ORACLE task unexpectedly died

1 Answers  


ORA-15016: invalid ASM_DISKGROUPS initialization parameter "string"

1 Answers  


ORA-27509: IPC error receiving a message

1 Answers  


ORA-00278: log file 'string' no longer needed for this recovery

1 Answers  


TNS-04001: %s

1 Answers  


ORA-22323: error table "string"."string" does not exist

1 Answers  


ORA-16150: FINISH recovery performed on another, older standby database

1 Answers  


Categories