Is there any way to reach the content of the DBMS_OUTPUT buffer after
calling an Oracle stored procedure from ASP/ADO?
calling an Oracle stored procedure from ASP/ADO?
-
-
Re: Retrieve the DBMS_OUTPUT buffer from ASP/ADO
"Agoston Bejo" <gusz1@freemail .huwrote in message
news:cimlbo$un2 $1@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.ENA BLE
DBMS_OUTPUT.GET _LINE
DBMS_OUTPUT.GET _LINES
++ mcs
-
Re: Retrieve the DBMS_OUTPUT buffer from ASP/ADO
"Mark C. Stock" <mcstockX@Xenqu ery .comwrote in message
news:l42dnSPPyc MCRtPcRVn-sg@comcast.com. ..
|
| "Agoston Bejo" <gusz1@freemail .huwrote in message
| news:cimlbo$un2 $1@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.ENA BLE
| 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
Comment
Comment