Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: DBMS_OUTPUT not printing . . .

Re: DBMS_OUTPUT not printing . . .

From: Boi Hue La <boihuel_at_montreal.src.ca>
Date: 1998/03/06
Message-ID: <35002006.C361EC37@montreal.src.ca>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US