Re: SQL*Plus problem

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