Passing query result to stored procedure.

[Narayanan]

Hi,

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).

EmployeeNames:
-------------------
Arul
Rahul
Raj

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.

[venkat]

i hope u can use pl sql collections

[Tim...]

Hi.

You can turn the results of the query into a comma separated string using string aggregation.

http://www.oracle-base.com/articles/mis ... niques.php

That string can then be passed into the procedure as a regular IN parameter.

Cheers

Tim...