Appending rows to a cursor

Is it possible to append rows to a cursor in PL/SQL (Oracle v7.3.4)? To specify a bit more. I need to loop through a cursor, passing parameters from that cursor to a SELECT statement (or cursor), and appending all resulting rows to a new cursor. When the loop is finished, I need to return the cursor (with the appended rows) from the function. In pseudo code it looks something like this:

CURSOR pre_cursor IS SELECT ...
CURSOR main_cursor(parameters) IS SELECT ...

OPEN pre_cursor
LOOP
 APPEND rows from pre_cursor to main_cursor END LOOP
RETURN main_cursor

I have posted a similar question once before, but never gotten a reply. Hopefully I'll have better luck this time.

Thanks in advance
Mathias

PS Don't forget to remove NOSPAM when replying via email. Received on Mon Aug 31 1998 - 01:50:32 CDT