470,594 Members | 1,345 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,594 developers. It's quick & easy.

Retrieve the DBMS_OUTPUT buffer from ASP/ADO

Is there any way to reach the content of the DBMS_OUTPUT buffer after
calling an Oracle stored procedure from ASP/ADO?
Jul 19 '05 #1
2 5963

"Agoston Bejo" <gu***@freemail.hu> wrote in message
news:ci**********@news.caesar.elte.hu...
| Is there any way to reach the content of the DBMS_OUTPUT buffer after
| calling an Oracle stored procedure from ASP/ADO?
|
|

you'll need to make appropriate DBMS_OUTPUT procedure calls both before and
after calling the stored procedure

complete information is available in PL/SQL Packages and Types Reference
(10g -- previously called the Supplied PL/SQL Packages and Types
Reference) -- available at http://tahiti.oracle.com

specifically, you'll want to look at:
DBMS_OUTPUT.ENABLE
DBMS_OUTPUT.GET_LINE
DBMS_OUTPUT.GET_LINES

++ mcs
Jul 19 '05 #2

"Mark C. Stock" <mcstockX@Xenquery .com> wrote in message
news:l4********************@comcast.com...
|
| "Agoston Bejo" <gu***@freemail.hu> wrote in message
| news:ci**********@news.caesar.elte.hu...
| | Is there any way to reach the content of the DBMS_OUTPUT buffer after
| | calling an Oracle stored procedure from ASP/ADO?
| |
| |
|
| you'll need to make appropriate DBMS_OUTPUT procedure calls both before
and
| after calling the stored procedure
|
| complete information is available in PL/SQL Packages and Types Reference
| (10g -- previously called the Supplied PL/SQL Packages and Types
| Reference) -- available at http://tahiti.oracle.com
|
| specifically, you'll want to look at:
| DBMS_OUTPUT.ENABLE
| DBMS_OUTPUT.GET_LINE
| DBMS_OUTPUT.GET_LINES
|
| ++ mcs
|
|
PS: just post stuff like this to one group (didn't notice that before my
first response) any other replies will be to just like
comp.databases.oracle.server

++ mcs
Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by Info 3000 | last post: by
reply views Thread by Agoston Bejo | last post: by
2 posts views Thread by Intrepid Soldier | last post: by
5 posts views Thread by Gidraz | last post: by
2 posts views Thread by Adam Teale | last post: by
5 posts views Thread by manheim | last post: by
2 posts views Thread by Agoston Bejo | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.