Re: Stored Procedure: How to output entire buffer

From: Bill Wordsworth <bill.wordsworth_at_gmail.com>
Date: Mon, 9 Jun 2008 11:30:35 -0700 (PDT)
Message-ID: <d383da52-dd22-4af2-9a3f-34cd9b2f11cd@8g2000hse.googlegroups.com>


On Jun 9, 2:09 pm, Bill Wordsworth <bill.wordswo..._at_gmail.com> wrote:
> I wrote a Stored Procedure wherein I use a Cursor to extract multiple
> rows and columns. I then write them into the buffer
> (dbms_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

In other words (maybe), how do I use dbms_output.get_lines() to assign value to an OUT variable?
Cheers, Bill Received on Mon Jun 09 2008 - 13:30:35 CDT

Original text of this message