Re: set serveroutput on

From: Johan Wegener <xjw_at_xdde.xdk>
Date: Wed, 18 Aug 1999 15:15:43 +0200
Message-ID: <7pebii$ifn$1@news101.telia.com>

Frans Laurijssen <fjl_at_kub.nl> skrev i en nyhedsmeddelelse:37BAA3CE.D524E3CF_at_kub.nl...
> Hello,
> I am a oracle developer and maybe this is not the correct group to post
> this question.

Well, I prefer c.d.o.tools for OCI questions, but - never mind ;-)

> 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?

Technically, yes by calling the "DBMS_OUTPUT.ENABLE" function. But then our client OCI program has to explicitly call the "DBMS_OUTPUT.GET*" functions to retrieve the content of the buffer. In SQL*Plus the calls to the GET functions are not visible.

> Question 2
> Is it possible to configure the server or my login account so that
> serveroutput is
> always on?

As far as I know: No. But some DBA may know better?

Cheers,
Johan Received on Wed Aug 18 1999 - 08:15:43 CDT