hi everybody!
thanks a lot for your concern and suggesting me the solution.
the actual problem that i'm facing is:

We have a stored procedure in which we want to pass a comma delimited list as one of the parameters. Inside the stored procedure I would like to use that list as part of a where clause using "in (commalist)". Howver
this raises an invalid number error.

The only two methods we can think of for such a
small query are:
1) Loop through the list to build some sort of a cursor containing each value in its own row then using that cursor in the query.
2) Build dynamic SQL and EXECUTTE IMMEDIATE it into a temporary table.
Then OPEN CURSOR FOR Select from that table.

If you can think of a less painful method please let me know.

Thanks and regards,
Amit Ahuja