Unanswered: Returning result set from Collection of local object
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.
select * from table(cast(obj_collection as CollectionType));
Note: Same worked if I define collection object globally
My basic requiement is to return ref cursor from collection object defined with in procedure. Can anyone please suggest solutions if any??