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

  • From: Jared Still <jkstill@xxxxxxxxx>
  • To: chiragdba@xxxxxxxxx
  • Date: Mon, 18 Oct 2004 09:30:51 -0700

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

Other related posts: