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

Home -> Community -> Usenet -> c.d.o.tools -> Re: SET SERVEROUTPUT ON SIZE - only 1000000 bytes?

Re: SET SERVEROUTPUT ON SIZE - only 1000000 bytes?

From: K Stahl <BlueSax_at_Unforgettable.com>
Date: 2000/02/15
Message-ID: <38A97498.4E3CB7A4@Unforgettable.com>#1/1

Miguel Nunes Pinto wrote:
>
> Hi,
> Thanks you
>
> But how (syntax) can i use utl_file and instead of what?
>
> >> *
> >> ERROR at line 1:
> >> ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes
> >> ORA-06512: at line 43
> >>
> >
> >Use utl_file instead - it does not have that limitation.
>
> Thanks.

Don't you have any documentation? It should have come with your Oracle server software. Beyond that, there are several good books on PL/SQL that are available. Received on Tue Feb 15 2000 - 00:00:00 CST

Original text of this message

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