How to flush the dbms_output buffer???
Trying to debug a PL/SQL procedure. It gets to a point where I beileve it gets caught up in an infinite loop (it should exit out at some point, but it isn't). I've got dbms_output.put_line statements before and inside the loop, hoping that they will help me identify the problem. I never see their output. If I comment out the problem infinite loop, I see the put_line strings I had before (outside) the loop, just like I'd expect.
Is PL/SQL buffering the dbms_output somewhere, then, when the procedure is done, it flushes the buffer? If so, Is there a way I can manually flush the buffer ahead of time?
Thanks
-dave