Re: [askdba] Re: ORA-03113: end-of-file on communication channel
On Mon, 18 Oct 2004 16:40:32 +0530, Chirag DBA <chiragdba@(protected):
> 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
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.
Certifiable Oracle DBA and Part Time Perl Evangelist