Integration

Hii

I have following scenario in my Project.
I have ERRORCODE Details Table in Database which has following columns.
1)ERRORCODE VARCHAR2
2)PRIORITY VARCHAR2
3)QueueName Varchar2

I have one web service which takes errorcode as input parameter of string type in which i have to pass values like 1,2,3.
Web service treated these values as complete one string value but i want it should be treated like seperately.Beacuse i have to pass these values to the query.

I have configured database adapter for the following query using Execute Pure SQL.

SELECT DISTINCT QueueName FROM ErrorCodeDetails where priority= (select min (priority) from ErrorCodeDetails where ErrorCode In(#ERRORCODE))


So can anyone please help me what changes i have to make in this query so the sql query treat the errorcode string value as three different value rather than one single value??

Thanks in advance.

Regards,
Priyanka