Re: Aborting PL/SQL script in Exception handler

Mike Hill_at_PW wrote:
>

-snip-

>
> This PL/SQL script kicks off a number of other Oracle scripts and
> procedures. Using dbms_output.put_line, I'm attempting to track progress on
> the screen. Unfortunately, if I encase the entire PL/SQL script as a single
> block with a global exception handler on the bottom, the
> dbms_output.put_line statements do not display to the screen as each script
> finishes, but rather all at once as soon as the entire PL/SQL is completed.

Sorry, but that's how dbms_output works. When you say dbms_output.put_line(), your text is stored in a buffer. It is up to SQL*Plus to execute dbms_output.get_lines(), and then to do printf's to display the output.

The only way I am aware of to track progress is to use Oracle pipes to send the messages to a daemon which writes the output to a file or another screen. You can look at the dbms_pipe script in the rdbms/admin directory for info on how to use Oracle pipes. I think the name is dbmspipe.sql or prvtpipe.sql.

Will.

-- 
======================================================================
Will Kooiman                        Computer Systems Authority
Systems Consultant                  6380 LBJ Freeway, Suite 181
(972) 960-0180 x236                 Dallas, TX 75240
mailto:wkooiman_at_csac.com            http://www.csac.com