Stored Procedure: How to output entire buffer

From: Bill Wordsworth <bill.wordsworth_at_gmail.com>
Date: Mon, 9 Jun 2008 11:09:08 -0700 (PDT)
Message-ID: <d2bbc00d-8ff4-40ed-a7c0-dc88b3cd53f9@j22g2000hsf.googlegroups.com>


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