Line overflow - dbms_output.put

From: Chua Boon Yiang <chuaby_at_hotmail.com>
Date: Fri, 12 Nov 1999 14:20:59 +0800
Message-ID: <80gbja$qti$1@newton.pacific.net.sg>

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 Fri Nov 12 1999 - 00:20:59 CST

Line overflow - dbms_output.put_line