Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: flushing DBMS_OUTPUT.putline output
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
![]() |
![]() |