Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: DBMS_OUTPUT not printing . . .
You have to type the instruction:
SET SERVEROUTPUT ON
if you want the DBMS_OUTPUT produce any output.
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 Fri Mar 06 1998 - 00:00:00 CST
![]() |
![]() |