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

From: Jared Still <jkstill_at_gmail.com>
Date: Mon, 18 Oct 2004 09:30:51 -0700
Message-ID: <bf4638041018093064f8ae5c@mail.gmail.com>

On Mon, 18 Oct 2004 16:40:32 +0530, Chirag DBA <chiragdba_at_gmail.com> 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

Received on Mon Oct 18 2004 - 11:26:27 CDT