Send DBMS Output to File (How or add to wish list)

[rzuniga]

Folks, I love PL/SQL Developer. However, one thing that bugs me is the buffer limit on the DBMS Output when testing a program.

I would assume that in order to avoid the buffer limit, one thing that PL/SQL Developer could do is route the screen output to a local file where the only limit is how much disk space you have in the PC.

Is there a way to do this? If not, then, please add to your list of future enhancements.

 

[Marco Kalter]

I assume you are aware that you can increase the buffer size before execution?

The buffer overflow occurs in the dbms_output package during execution of your PL/SQL program. The buffer can only be read after execution, which is too late to avoid the overflow. I don't see how this can be prevented.

------------------
Marco Kalter
Allround Automations

 

[tcogill]

As Marco mentioned, this is an Oracle _feature_ and simply how dbms_output works.

As a possible work-around/solution, try creating a logging routine that writes messages to a table. Then instead of using dbms_output, call this procedure. Utilize autonomous transactions to commit the log message and not affect your program.

Good luck.
- Tim