Re: direct dbms_output to a non-sqlplus client

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".

Will Kooiman
Computer Systems Authority
wkooiman_at_csac.com Received on Tue Oct 29 1996 - 00:00:00 CET