I am using oracle 10g version. Can any one please tell me how to pass the query result to IN clause of oracle stored procedure..?
For Example: I have a Employee table which returns only employee names ( select employeeNames from Emplyoee -> this query returns more than 100 employee names).
In my oracle stored procedure, I want to pass these values to comma seperated string....
I have stored the query result in one variable like employee_query="select employeeNames from Employee". Now my requirement is how to pass this query result as comma seperated strings to IN clause of my stored procedure?
Thanks in Advance.