Stored Procedure: How to output entire buffer

From: Bill Wordsworth <>
Date: Mon, 9 Jun 2008 11:09:08 -0700 (PDT)
Message-ID: <>

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

Original text of this message