From: Joerg Heinrich <joerg.heinrich@medienhaus-bremen.de>
Subject: Re: DBMS_OUTPUT not printing . . .
Date: 1998/03/03
Message-ID: <34FC2ABA.4E0255A7@medienhaus-bremen.de>#1/1
Content-Transfer-Encoding: 7bit
References: <DA7A9D0CBC2A0825.120B9F3732CFCFE7.447700676252C782@library-proxy.airnews.net>
X-Server-Date: 3 Mar 1998 16:10:03 GMT
Mime-Version: 1.0
Reply-To: joerg.heinrich@medienhaus-bremen.de
To: Douglas Heydrick <heydrick@airmail.net>
Content-Type: text/plain; charset=us-ascii
Organization: multi media haus bremen
Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.server,comp.databases.oracle.tools



Hi,
you have to execute the SQL*Plus command
  set serveroutput on
before you can get any output from dbms_output.
The output buffer used by dbms_output is default limited to 2000 bytes,
you can modify this limit with
  set serveroutput on size n
where n can between 2000 and 1000000.

I hope this is helpful for you
Joerg Heinrich


Douglas Heydrick wrote:

> A stored procedure exists on database 'A' (proc).  I tried to execute said
> procedure from database 'B' within SQL*Plus (execute proc@A).  There are
> DBMS_OUPUT statements in the stored procedure which do not produce any
> output from the SQL*Plus session on database 'B'.
>
> doug
>
> heydrick@airmail.net