ERROR at line 1:
ORA-20000: ORU-10028: line length overflow, limit of 255 bytes per line
ORA-06512: at "SYS.DBMS_OUTPUT", line 84
ORA-06512: at "SYS.DBMS_OUTPUT", line 58
ORA-06512: at line 2

i got the above error when i tried to display a line which has more than
1000 letters altogether in a single dbms_outpu.put_line function call.
is there anyway that we can overcome this!

ur's help would be greatly appreciated,
Prabhakar
Oracle LazyDBA home page