Re: Returning data from temp_tables

BGT wrote:
> The code you returned to me is basically the same as what I had
> above. What you have repeatedly failed to realize is that maillist
> has to be filled in by the result set of many labno's not just one,
> hence this whole cursor loop is part of a larger cursor. The fetch is
> used to fill in a temp table from which maillist is filled for final
> output. Unless you have a way to append records to an existing cursor
> I don't see any other way of doing it since in your code above
> maillist will clear out with each iteration of labno. I read each of
> your post quite closely it's a shame you did not do the same.

It is rather simple to do so but given that you've whacked all previous information such as the nature of the issue and version number I can't help beyond saying it can be done rather simply.

One example can be found here:
http://www.psoug.org/reference/control_struct.html scroll down to: "Nested Cursor Loops" and "Nested Loops with Bulk Collect"

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org