Stored Procedure: How to output entire buffer
Date: Mon, 9 Jun 2008 11:09:08 -0700 (PDT)
I wrote a Stored Procedure wherein I use a Cursor to extract multiple rows and columns. I then write them into the buffer (dmbs_output.put_line). But when I try to capture the entire result into an OUT variable, I only get the last buffered line.
So how do I output the entire buffer- all rows and columns? Cheers, Bill Received on Mon Jun 09 2008 - 13:09:08 CDT