I am using below oracle query which is working fine –

SELECT col_1
  FROM table_1
 WHERE col_1 IN (SELECT col_a
                   FROM table_2)

It starts giving “Invalid number” as soon as I include an Or condition in this query as below –

SELECT col_1
  FROM table_1
 WHERE col_1 IN (SELECT col_a
                   FROM table_2)
    OR col_1 IN (1, 2, 3)

I already tried interchanging the conditions. It is working fine with 1 condition and start giving error as soon as I add another condition.
Both the columns col_1 and col2 in the tables table_1 and table_2 have the same datatype as “Number” still I tried to use TO_NUMBER function but nothing seems to work here.