Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Perplexed by PL/SQL error

Re: Perplexed by PL/SQL error

From: Gennaro Napolitano <Gennaro.Napolitano_at_italdata.it>
Date: Tue, 13 Jul 1999 10:27:59 +0200
Message-ID: <378AF88E.4980BD85@italdata.it>

Juan Carlos wrote:

> I don't have a lot of experience with PL.SQL, but mananged to get the
> following to compile to do a delete from a table containing hundreds of
> thousands of records. The commit level is set artificially low here for
> testing. After running for a bit, it quits with an error shown after to
> code. Does it mean anything to anyone? I see in the doc that DBMS_OUTUPUT
> writes to a buffer in the SGA. Do I need to purge this buffer somehow?
>
> SET SERVEROUTPUT ON
Try this:
  set serveroutput ON size 1000000

Ciao Gennaro Received on Tue Jul 13 1999 - 03:27:59 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US