 | |
Stored Procedure: How to output entire buffer
comp.databases.oracle.misc comp.databases.oracle.misc
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Stored Procedure: How to output entire buffer -
06-09-2008
, 01:09 PM
#2
| |||
| |||
|
|
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 |
value to an OUT variable?
Cheers, Bill
#3
| |||
| |||
|
|
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 |
value to an OUT variable?
Cheers, Bill
#4
| |||
| |||
|
|
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 |
value to an OUT variable?
Cheers, Bill
#5
| |||
| |||
|
|
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 |
value to an OUT variable?
Cheers, Bill
#6
| |||
| |||
|
|
On Jun 9, 2:09?pm, Bill Wordsworth <bill.wordswo... (AT) gmail (DOT) 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 |
approach. Most likely you just want to make your OUT variable a ref cursor.
If there's some reason you can't do that, create a record collection type, make
the variable that type, and put the cursor results into the variable.
DBMS_OUTPUT is designed to display results - it's not meant to be used like
this.
--
__________________________________________________ _____________________
Dan Blum tool (AT) panix (DOT) com
"I wouldn't have believed it myself if I hadn't just made it up."
#7
| |||
| |||
|
|
On Jun 9, 2:09?pm, Bill Wordsworth <bill.wordswo... (AT) gmail (DOT) 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 |
approach. Most likely you just want to make your OUT variable a ref cursor.
If there's some reason you can't do that, create a record collection type, make
the variable that type, and put the cursor results into the variable.
DBMS_OUTPUT is designed to display results - it's not meant to be used like
this.
--
__________________________________________________ _____________________
Dan Blum tool (AT) panix (DOT) com
"I wouldn't have believed it myself if I hadn't just made it up."
#8
| |||
| |||
|
|
On Jun 9, 2:09?pm, Bill Wordsworth <bill.wordswo... (AT) gmail (DOT) 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 |
approach. Most likely you just want to make your OUT variable a ref cursor.
If there's some reason you can't do that, create a record collection type, make
the variable that type, and put the cursor results into the variable.
DBMS_OUTPUT is designed to display results - it's not meant to be used like
this.
--
__________________________________________________ _____________________
Dan Blum tool (AT) panix (DOT) com
"I wouldn't have believed it myself if I hadn't just made it up."
#9
| |||
| |||
|
|
On Jun 9, 2:09?pm, Bill Wordsworth <bill.wordswo... (AT) gmail (DOT) 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 |
approach. Most likely you just want to make your OUT variable a ref cursor.
If there's some reason you can't do that, create a record collection type, make
the variable that type, and put the cursor results into the variable.
DBMS_OUTPUT is designed to display results - it's not meant to be used like
this.
--
__________________________________________________ _____________________
Dan Blum tool (AT) panix (DOT) com
"I wouldn't have believed it myself if I hadn't just made it up."
#10
| |||
| |||
|
|
In comp.databases.oracle.misc Bill Wordsworth <bill.wordswo... (AT) gmail (DOT) com> wrote: On Jun 9, 2:09?pm, Bill Wordsworth <bill.wordswo... (AT) gmail (DOT) 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 I'm sure exactly what you're trying to do here, but I doubt this is the correct approach. Most likely you just want to make your OUT variable a ref cursor.. If there's some reason you can't do that, create a record collection type,make the variable that type, and put the cursor results into the variable. DBMS_OUTPUT is designed to display results - it's not meant to be used like this. |
cursor_out_test OUT cursor_test
But when I try:
DEFINE CURSOR TYPE cursor_test IS REF CURSOR RETURN table%ROWTYPE;
...or...
DECLARE TYPE cursor_test IS REF CURSOR RETURN table%ROWTYPE;
I get errors.
Cheers, Bill
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.