OraFAQ Forum: SQL & PL/SQL » Re: Buffer limit in DBMS

Home » SQL & PL/SQL » SQL & PL/SQL » Re: Buffer limit in DBMS_OUTPUT

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Re: Buffer limit in DBMS_OUTPUT [message #365476]

Mon, 29 June 1998 06:23

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.

Report message to a moderator

Re: Buffer limit in DBMS_OUTPUT [message #365478 is a reply to message #365476]

Mon, 29 June 1998 15:08

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?

Report message to a moderator

Re: Buffer limit in DBMS_OUTPUT [message #365479 is a reply to message #365478]

Mon, 29 June 1998 15:15

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.

Report message to a moderator

Re: Buffer limit in DBMS_OUTPUT [message #365480 is a reply to message #365479]

Mon, 29 June 1998 15:35

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?

Report message to a moderator

Previous Topic:	PROCEDURE CALLED ERROR
Next Topic:	Reference Cursor Variable for Dynamic Tables?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 28 15:47:06 CDT 2023