Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: set serveroutput on
you could create a .login file from where you call
sqlplus - the .login file containing 'set serveroutput on'.
Johan Wegener wrote:
>
> 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 - 09:51:08 CDT