Using REF CURSOR in a SQL query

[paragmaydeo]

Hi,

I have a procedure p1 giving a ref cursor as o/p c1.

Now I want to use the result set of this query DIRECTLY into a SQL query as follows....

SELECT a.col1 from a where a.col2 IN (select c1.col2 from c1);

Now, is this possible by ANY WAY??

If so, then HOW??

Thanking in advance.

Regards,
Parag.