ORA-01722: invalid number

Oracle 9i DB

 

I am passing a number to a query through the bind :col1 as an IN NUMBER and am receiving the 01722 error on the OR part of the WHERE clause.

 

If I remove the OR statement the query returns as expected but when I include the OR it returns 01722 error.

 

I checked the data in the column of both tables and the column type is NUMBER and all the data in the columns are a number.

 

Any ideas from the collective?

 

SELECT COL1,COL2,COL3

FROM TABLE

WHERE :COL1 = 999999 AND COL1_ID IN (SELECT COL1_ID FROM OTHERTABLE