Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Retrieve the DBMS_OUTPUT buffer from ASP/ADO

Re: Retrieve the DBMS_OUTPUT buffer from ASP/ADO

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Mon, 20 Sep 2004 09:32:54 -0400
Message-ID: <q_-dnct_qJaGQdPcRVn-og@comcast.com>

"Mark C. Stock" <mcstockX_at_Xenquery .com> wrote in message news:l42dnSPPycMCRtPcRVn-sg_at_comcast.com...
|
| "Agoston Bejo" <gusz1_at_freemail.hu> wrote in message
| news:cimlbo$un2$1_at_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 Received on Mon Sep 20 2004 - 08:32:54 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US