Home » Developer & Programmer » Forms » Comparision between number and varchar2 string
Comparision between number and varchar2 string [message #362806] Thu, 04 December 2008 03:15 Go to next message
Messages: 8
Registered: September 2008
Junior Member

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.

Re: Comparision between number and varchar2 string [message #362831 is a reply to message #362806] Thu, 04 December 2008 04:05 Go to previous message
Messages: 21148
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Search for "varying elements in IN list" (either here, or Ask Tom).
Previous Topic: Executing Query through parameter
Next Topic: To Generate Trace File
Goto Forum:

Current Time: Sat Aug 19 06:26:00 CDT 2017

Total time taken to generate the page: 0.06235 seconds