dbTalk Databases Forums  

Retrieve the DBMS_OUTPUT buffer from ASP/ADO

comp.databases.oracle comp.databases.oracle


Discuss Retrieve the DBMS_OUTPUT buffer from ASP/ADO in the comp.databases.oracle forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Agoston Bejo
 
Posts: n/a

Default Retrieve the DBMS_OUTPUT buffer from ASP/ADO - 09-20-2004 , 08:15 AM






Is there any way to reach the content of the DBMS_OUTPUT buffer after
calling an Oracle stored procedure from ASP/ADO?



Reply With Quote
  #2  
Old   
Mark C. Stock
 
Posts: n/a

Default Re: Retrieve the DBMS_OUTPUT buffer from ASP/ADO - 09-20-2004 , 08:30 AM







"Agoston Bejo" <gusz1 (AT) freemail (DOT) hu> wrote

Quote:
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




Reply With Quote
  #3  
Old   
Mark C. Stock
 
Posts: n/a

Default Re: Retrieve the DBMS_OUTPUT buffer from ASP/ADO - 09-20-2004 , 08:32 AM




"Mark C. Stock" <mcstockX@Xenquery .com> wrote

Quote:
"Agoston Bejo" <gusz1 (AT) freemail (DOT) hu> wrote in message
news:cimlbo$un2$1 (AT) news (DOT) 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




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.