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

Home -> Community -> Usenet -> c.d.o.server -> SQL*Plus problem

SQL*Plus problem

From: Gennaro Napolitano <Gennaro.Napolitano_at_sbsitalia.it>
Date: Tue, 18 May 1999 15:36:12 +0200
Message-ID: <37416CCC.B8F21665@sbsitalia.it>


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 - 08:36:12 CDT

Original text of this message

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