Re: DBMS_OUTPUT not printing . . .
From: Joerg Heinrich <joerg.heinrich_at_medienhaus-bremen.de>
Date: 1998/03/03
Message-ID: <34FC2ABA.4E0255A7_at_medienhaus-bremen.de>#1/1
Date: 1998/03/03
Message-ID: <34FC2ABA.4E0255A7_at_medienhaus-bremen.de>#1/1
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_at_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_at_airmail.net
Received on Tue Mar 03 1998 - 00:00:00 CET