Re: set serveroutput on

Are you trying to use dbms_output inside the pl/sql? If so, what you really need to do is write a listener which will perform a dbms_output.get_line to retrieve the data from the implicit pipe that dbms_output uses.

However, I'd recommend that you do not use dbms_output in a pl/sql block that is embedded in an OCI program unless you know absolutely that yours is the only program that will ever use dbms_output. The moment you create a listener it will received everything written to dbms_output no matter what program puts it there. You'd be better off using dbms_pipe and having an implicit pipe. That way when you can listen just for one particular pipe identifier.

Frans Laurijssen wrote:

> Hello,
> I am a oracle developer and maybe this is not the correct group to post
> this question.
> I am using oci and PL/SQL and trying to call a procedure from oci.
> I need to set the equivalent of 'set serveroutput on' from the SQLPlus
> sql
> interpreter in my OCI program because the output is not returned to my
> program.
> Question 1
> Can I do this from my oci program?
> Question 2
> Is it possible to configure the server or my login account so that
> serveroutput is
> always on?
>
> Thanks
> Please reply to fjl_at_kub.nl
Received on Wed Aug 18 1999 - 09:41:25 CDT