Non-buffered PL/SQL output?

From: Francis M Small <fthes_at_sr.hp.com>
Date: 28 Sep 1999 17:18:46 GMT
Message-ID: <7sqt9m$dvm@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 ***********************

Received on Tue Sep 28 1999 - 12:18:46 CDT