Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: flushing DBMS_OUTPUT.putline output

Re: flushing DBMS_OUTPUT.putline output

From: James Petts <jpetts_at_celltech.co.uk>
Date: Thu, 14 Jan 1999 09:12:59 GMT
Message-ID: <369db48b.70884035@firewall.celltech>


Below is a similar question that I answered, and which gave the information which you need.

>I have a problem using the dbms_output.put_line('MY_STRING') within a
>PL/SQL-Package-Procedure. This command shows its output only, if the
>procedure is finished. Is there a way to produce within
>PL/SQL-Package-Procedure a output to the screen, something like a status
>bar, to tell the user, what's going on?

 Not directly: DBMS_OUTPUT output is buffered, and is only output at  the end of the procedure. Also, if the procedure terminates with an  unhandled error, then you may not get to see the output at all. What  you need to do is encapsulate the calls to DBMS_OUTPUT in procedures  of your own, best done using a package. The difference is that when  you call your output routine, you will get the output as soon as your  output terminates.

 Absolutely the best place to look for information of this kind is in  the three books written (or co-written) by Steven Feuerstein and  published by O'Reilly & Associates. He has written a marvellous piece  of software called PL/Vision which includes the functionality  outlined above. You can download this from http://www.revealnet.com  and try it for free for thirty(?) days. Alternatively, there is a  free, but less functional version available from the same site.

James Petts

On 13 Jan 1999 21:27:20 GMT, wagner_at_cs.umn.edu (Paul Wagner) wrote:

>I've noticed that if I have debugging output in a PL/SQL procedure
>using DBMS_OUTPUT.putline(), it all is displayed after execution
>is complete. Is there any way of flushing the output at the point
>of its particular execution? I'd like to see the relative amount
>of time different parts of the procedure take, and it would be
>helpful to see the output as the statements are being executed
>rather than all at the end.
>
Received on Thu Jan 14 1999 - 03:12:59 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US