Re: Retrieve the DBMS_OUTPUT buffer from ASP/ADO
From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Mon, 20 Sep 2004 09:30:50 -0400
Message-ID: <l42dnSPPycMCRtPcRVn-sg_at_comcast.com>
Date: Mon, 20 Sep 2004 09:30:50 -0400
Message-ID: <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:
++ mcs
Received on Mon Sep 20 2004 - 15:30:50 CEST
DBMS_OUTPUT.ENABLE
DBMS_OUTPUT.GET_LINE
DBMS_OUTPUT.GET_LINES