Re: direct dbms_output to a non-sqlplus client

hi,
If you look at the description of the dbms_output package you'll see a function named dbms_output.enable(size in number). From your oci program you can call this function to enable dbms_output calls. Then, after each oexec (or oexn) you call dbms_output.get_line or dbms_output.get_lines to retrieve the output. (check function names, i'm not sure about them).

--
Gert Rijs
mailto:gem_at_wirehub.net    (at home)
mailto:gert.rijs_at_corp.ah.nl (at work)

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

> --