Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Perplexed by PL/SQL error
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