Re: SQL*Plus problem

From: <tedchyn_at_yahoo.com>
Date: Wed, 19 May 1999 15:00:41 GMT
Message-ID: <7hujmm$4m2$1@nnrp1.deja.com>

ciao, this is a limitation for dbms_output and there is code out in www.oramag.com/code/ tells you how to get around this problem.

Ted
In article <37416CCC.B8F21665_at_sbsitalia.it>, Gennaro Napolitano <Gennaro.Napolitano_at_sbsitalia.it> 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.
>
>

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Wed May 19 1999 - 10:00:41 CDT