Re: DBMS_OUTPUT not printing . . .

additions to other replies:

1. use

        set serverout on size 1000000 format wrapped

in later versions of SQL*Plus (3.3.x+). The "format wrapped" bit means that leading white space and blank lines will be printed, as they are otherwise not.

2. when you issue a "connect uid/pwd", serveroutput will revert to off, so remember to set in back on.

3. output does not appear until the proc completes. If you want intermediate output, you'll need to send stuff using dbms_pipe to another session, or write to a table and commit.

-- 
Andrew - Wizzard

barnetaj_at_bp.com

Douglas Heydrick <heydrick_at_airmail.net> wrote in article
<DA7A9D0CBC2A0825.120B9F3732CFCFE7.447700676252C782_at_library-proxy.airnews.ne
t>...


> 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'.