Home » SQL & PL/SQL » SQL & PL/SQL » Re: Buffer limit in DBMS_OUTPUT
Re: Buffer limit in DBMS_OUTPUT [message #365476] Mon, 29 June 1998 06:23 Go to next message
David Calobrisi
Messages: 5
Registered: June 1998
Junior Member
dbms_output.enable(100000);

The buffer limit default is 2000. It can be as
large as 1,000,000.
Re: Buffer limit in DBMS_OUTPUT [message #365478 is a reply to message #365476] Mon, 29 June 1998 15:08 Go to previous messageGo to next message
Pakku
Messages: 3
Registered: June 1998
Junior Member
Thanks for the help. I know I wouldnt exceed that limit. I was wondering is there any way you could flush the buffer from within the procedure that is pumping the output?
Re: Buffer limit in DBMS_OUTPUT [message #365479 is a reply to message #365478] Mon, 29 June 1998 15:15 Go to previous messageGo to next message
David Calobrisi
Messages: 5
Registered: June 1998
Junior Member
not sure what you mean. Just put the command
DBMS_OUTPUT.ENABLE(100000);
at the top of your procedure before you try to write anything with DBMS_OUTPUT.PUT_LINE.
That should be all you need to do.
Re: Buffer limit in DBMS_OUTPUT [message #365480 is a reply to message #365479] Mon, 29 June 1998 15:35 Go to previous message
Pakku
Messages: 3
Registered: June 1998
Junior Member
I understood the way to bounce the limit. What I am asking now is can I flush and clear the buffer from within the procedure. I mean if I have my DBMS_OUTPUT stmt in a loop, can I reset the buffer every 1000 records? That way I will never run into the buffer problem right?
Previous Topic: PROCEDURE CALLED ERROR
Next Topic: Reference Cursor Variable for Dynamic Tables?
Goto Forum:
  


Current Time: Thu Jun 24 23:55:49 CDT 2021