Re: dbms_output (buffer overflow)

PowerD_at_logica.com Asks:

• I'm already setting the buffer to the maximum possible size and I still

--get the overflow problem. this occurrs as I'm using DBMS_OUT.PUT_LINE
--statements in a loop for reporting errors. Unfortunately, if every
record
--I'm processing generates an error I overflow the buffer.

--Is there any way to flush or clear the buffer.

If you are at PL/SQL 2.2 or higher,
You might avoid using DBMS_OUTPUT if you are over-running the 1meg buffer.  You could use the UTL_FILE (file i/o ) and send output to a file and then do whatever with it when the script completes (which is what DBM_OUTPUT does anyway).

Good Luck.

Alex Jentilucci - Consultant
Information System Dynamics, Inc
Minneapolis, MN 55323
Tele: 612-476-7395 FAX: 612-473-5954 E-Mail: infosys_at_aol.com

E-Mail Work: jentilucci_at_notes.seagate.com

          Home: AlexJent_at_aol.com Received on Wed Mar 05 1997 - 00:00:00 CST