Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Line overflow - dbms_output.put_line
HI!
set long 1000000
Regards
Thorsten
Chua Boon Yiang schrieb:
>
> Hi
> i am trying to
> dbms_output.put_line a very long line. but i got this error message
> when i execute the PL/SQL in SQL*Plus.
>
> ERROR at line 1:
> 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
> ORA-06512: at line 12
>
> i have tried
>
> SET SERVEROUTPUT ON FORMAT WORD_WRAPPED
> SET LINESIZE 2000
> set lines 5000
> set pages 5000
>
> But i still get the error.
>
> May i know how can i extend the length of line inorder print out a very long
> string of varchar2(2000).
>
> Thanks
> Boon Yiang
Received on Sat Nov 13 1999 - 02:17:53 CST