Select on Cursor

Hi Friends,

I have written a function that executes a DDL statement which inturn creates a view. Once the view is created i fetch the data from that view and drop the view again. I could have kept the view in the database but it leads to a performance issue as select to any table refreshes the view too!, so i resorted to creation & dropping of view at run-time.

Now, i am trying to take another approach, i have made a function which instead of creating a view, returns a cursor containing the resultset on which i need to do a select statement.

Now, i am now sure, whether its possible to execute a select statement on a cursor (resultset) or not.

Please help me with this one.

Thanx alot.
Gaurav.