Hello all,
I have a requirement where i need to pass a string of numbers to a column of number datatype.
When i pass the string of number as parameters ( ex '123,345,2354,456), this is being passed on as a number to column datatype with single quotes around it and so producing "Invalid Number" message.
Parameter = '123,234,355,46567'
Oralce query
select 1 from xxx
where ID in (Parameter) -- ID is an integer and so throwing "Invalid Number" message.
How can i remove the single quotes around the parameter while passing it to ID for comparision
We are using 10g oracle
Appreciate your responses.