Re: direct dbms_output to a non-sqlplus client

Instead of "set server output" use dbms_output.enable(<buffer length>). After executing PL/SQL block or procedure containing dbms_output.pu_line('xx') calls, use dbms.get_line to retrive results.

Victor Poteryahin.

Ming-Ding Tsao <mtsao_at_cas.org> wrote in article <x6eohhsqwjt.fsf_at_atl01s4u.i-have-a-misconfigured-system-so-shoot-me>...
> 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
> --
>
  Received on Fri Oct 25 1996 - 00:00:00 CEST