Re: question

From: Pradhan <empradhan_at_dplus.net>
Date: Mon, 14 Jun 1999 20:43:21 -0400
Message-ID: <Mjh93.187$B04.1229@newsfeed.slurp.net>

hi
you can set the environment
as

set serveroutput on size 1000000

which is 1M(close to) and this size of memory is allocated during the your session is on ...

good luck

pradhan
hamid wrote in message <376582bc_at_news1.vip.uk.com>...
>I've got the following error message when I use DBMS_OUTPUT.Enable(20000)
as
>part of the procedure to load the data:
>ORA-20000: ORU-10027: buffer overflow, limit of 20000 bytes.
>where is the problem.
>
>any help will be appreciated.
>
>Hamid
>
>
Received on Mon Jun 14 1999 - 19:43:21 CDT