Oracle Solution for Error ora-01470

Solution for Oracle Error ORA-01470

ORA-01470: In-list iteration does not support mixed operators

What triggered the Error:

Constants of different types are specified in an in-list.

What should we do to fix it:

Use constants of same type for in-lists.