Re: SYS.DBMS_OUTPUT buffer overflow... Limited to 2000 bytes of output.(?)

From: Jeremy Barnsley <jeremy.barnsley_at_syntegra.bt.co.uk>
Date: 1997/04/11
Message-ID: <334E9322.6CD9_at_syntegra.bt.co.uk>#1/1


In SQL*Plus, do the following :-

        exec dbms_output.enable(50000)

This will give you a buffer size of 50000 chars (or whatever value you enter). Then run your procedure which uses dbms_output. Received on Fri Apr 11 1997 - 00:00:00 CEST

Original text of this message