DBMS_OUTPUT... buffer full !!

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Mon, 5 Aug 2002 16:49:39 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA702771F0A@lnewton.leeds.lfs.co.uk>

Mahesh,

have you called DBMS_OUTPUT.Enable(1000000) as part of the proc ? If not you have a prtetty small buffer.
The maximum buffer size is 1 million (Oracle 7 and 8.0) or 2 million (Oralce 8i) [I think !!!] and you cannot, as far as I am aware, exceed these limits.

The only way to flush the buffer is :

	read from it in the same session that wrote to it (GET_LINE)
	disable output and re-enable it - but this trashes the contents

of the buffer.

Basically, the things you don't want *are* the things you need - sorry.

Regards,
Norman.

---

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com


-------------------------------------

-----Original Message-----
From: Mahesh [mailto:HalpethM_at_Logica.com] Posted At: Monday, August 05, 2002 2:20 PM Posted To: server
Conversation: DBMS_OUTPUT... buffer full !! Subject: DBMS_OUTPUT... buffer full !!

Hi Oracle_Gurus,

Is there a way that one could avoid crash of a PL/SQL script using DBMS_OUTPUT.PUT_LINE,
for filling up the buffer ??

No way of flushing out the buffer and then re-initialising it ?

Not looking for a Pro*C or utl_file or inserting into a table ... or a dbms_pipe solution...

Thanks,

Mahesh. Received on Mon Aug 05 2002 - 10:49:39 CDT