Re: [askdba] Re: ORA-03113: end-of-file on communication channel

On Mon, 18 Oct 2004 16:40:32 +0530, Chirag DBA <chiragdba@xxxxxxxxx> wrote:
> And one more question..
> Is the anyway to execute the DBMS_OUTPUT package as soon as they occur.

No, dbms_output output will not appear until execution of the PL/SQL
has completed.
It will however crash immediately if you exceed 1M output.  

Try using PIPE ROW - no limits on output.  The concept takes a little getting
used to when you consider how it works, but it work well.

You could also use DBMS_PIPE, and retrieve the pipe output in another session.

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
http://www.freelists.org/webpage/oracle-l

Other related posts: