Hi all From the front end ( jsp) i am passing a string parameter which has comma seperated primarykeys and i am using this string in writing a query and ia m saying there IN (string) but this is giving me ORA-01722: invalid number error.
For example from jsp i am passing a string called ebcnIds=2222,2223 and in my backend ia m executing query which is having EBCN_ID IN (ebcnIds) where EBCN_ID is my primarykey in the table of type NUMBER .. Can any one help me in this regard??? Regards Sreenath
Well, the only thing I can guess is that you have this string as part of your query string "EBCN_ID IN (ebcnIds)" so it is using the literal "ebcnIds" instead of the actual values in your String object. try concatenation like "EBCN_ID IN (" + ebcnIds + ")" Hope that is the reason. Mark