Re: direct dbms_output to a non-sqlplus client

From: michael j miller <mmiller_at_crusoe.net>
Date: 1996/10/30
Message-ID: <558cnj$evp_at_crusoe.crusoe.net>#1/1


On Tue, 29 Oct 1996 00:22:36 -0600,

         Will Kooiman wrote:
>Ming-Ding Tsao wrote:
>>
>> In sqlplus a user can do "set serveroutput on" to receive the stored
>> procedures's "dbms_output" output such as
>> "dbms_output.put_line('pro_name')" when the procedure is called and
>> finished.
>>
>> How about a client using OCI ? If it sends out a PLSQL block which
>> contains a procedure call who calls dbms_output
>>
>> Thanks in advance, Ming Tsao
>> --
 

>Take a look at the dbms_output package. There are functions
>dbms_output.get_lines, etc. These are for Pro*C and OCI, to use to
>get this output.
 

>I am pretty sure SQL*Plus is simply executing these calls for you
>when you say "set serveroutput on".

It is .... Received on Wed Oct 30 1996 - 00:00:00 CET

Original text of this message