| Comparision between number and varchar2 string [message #362806] |
Thu, 04 December 2008 03:15  |
hiteshkanjaria
Messages: 8
Registered: September 2008
|
Junior Member |
|
|
Hi,
I have a table called test1(col1 number,col2 varchar2).
I want to query the data from the table by filtering col1 column.
Now I am executing the query,
Select * from test1 where col1 IN (:var_name);
by passing the string (12,23,54,76,34) of type varchar2. So when I comparing it it gives me error of ORA-01722.
Can you suggest me how to solve the problem.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
