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

Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL*Plus problem

Re: SQL*Plus problem

From: Gerald Bull <gerald.bull_at_fmr.com>
Date: Tue, 18 May 1999 10:11:16 -0400
Message-ID: <37417504.F4F1A827@fmr.com>


It is a limitation of the DBMS_OUTPUT package. You will need to break up your lines into 255 character chunks.

Jerry.

Gennaro Napolitano wrote:

> Hy all
>
> I have a problem using the dbsm_putput package in SQL*Plus, if I try to
> display a line longer than 255 byte I receive the following error:
>
> ORA-20000: ORU-10028: line length overflow, limit of 255 bytes per line
> ORA-06512: at "SYS.DBMS_OUTPUT", line 99
> ORA-06512: at "SYS.DBMS_OUTPUT", line 65
>
> Somebody knows which is the SQL*Plus parameter I have to modify to avoid
> this problem?
> I tried with linesize parameter but it still does not work.
>
> Thanks a lot in advance
>
> Ciao Gennaro
> --
> "Buongiorno signor De Filippo, qui e' la Televisione". "Va bene, aspetti
> che le passo il frigorifero" disse Eduardo De Filippo.
Received on Tue May 18 1999 - 09:11:16 CDT

Original text of this message

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