Re: DBMS_OUTPUT not printing . . .
Date: 1998/03/03
Message-ID: <6dii8c$1eu$1_at_nnrp1.dejanews.com>#1/1
In article <DA7A9D0CBC2A0825.120B9F3732CFCFE7.447700676252C782_at_libraryproxy.
airnews.net>,
"Douglas Heydrick" <heydrick_at_airmail.net> 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
>
>
You need to include the line
set serveroutput on;
at the start of your SQL*PLUS script.
-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Tue Mar 03 1998 - 00:00:00 CET