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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
