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 ...
APPEND rows from pre_cursor to 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
PS Don't forget to remove NOSPAM when replying via email.