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.