Re: Non-buffered PL/SQL output?

You could write it to a pipe using dbms_pipe instead, then have another session read from the pipe and display it. I wrote a very simple Delphi app to do this. It displayed the pipe messages.

--
- Dan Clamage
http://www.telerama.com/~dclamage
If you haven't crashed the Server,
you haven't been trying hard enough.
Francis M Small <fthes_at_sr.hp.com> wrote in message news:7sqt9m$dvm_at_canyon.sr.hp.com...
> You know how in an sqlplus script if you have:
>
> begin
> dbms_output.put_line('Start');
> dbms_lock.sleep(5);
> dbms_output.put_line('End');
> end;
> /
>
> that nothing gets printed out until the end of the job. As opposed to
> having 'Start' printed immediately before sleeping for 5 secons.
> Yes, I could break up the above simple example into separate
> PL/SQL blocks, but the actual case involves a single PL/SQL modules
> that isn't conveniently broken up. Is there any way to flush PL/SQL
> output to standard out? I also got the impression from another post that
> the way to go might be to use the DBMS_ALERT package, although this
> might be more cumbersome. Thanks.
>
> Francis
>
> --
> . . . . . 5 . . . . 10. . . . 15. .|. . 20. . . . 25. . . . 30. . . . 35.
. .
> Diamondbacks Francis Small - M/S M1RA
> Giants Test Engineering
> Bums Microwave Instruments
Div
> Padres telnet 794-3305
> Rocki fthes_at_sr.hp.com
> *********************** National League West Standings