Hi All,
I am new to this forum. I wrote a procedure which returns ref cursor from collection of locally defined objects. Of cource Collection object also defined locally(with in procedure). Procedure gets hanging while executing the following statement.

open refcursor
select * from table(cast(obj_collection as CollectionType));

Note: Same worked if I define collection object globally

Any clues/suggestions??

My basic requiement is to return ref cursor from collection object defined with in procedure. Can anyone please suggest solutions if any??