set serveroutput on size 1000000






"Vikrant Jindal"
<[Email Address Removed] To: "LazyDBA.com Discussion" <[Email Address Removed]
rvice.com> cc:
Subject: RE: dbms output problem..
February 28,
2002 06:29 PM






U can try using UTL_FILE package. You can't pass in the string which has
got
more than 255 characters to DBMS_OUTPUT function.


Vikrant J.

-----Original Message-----
From: Prabhakaran, K [mailto:K.[Email Address Removed] Friday, March 01, 2002 10:24 AM
To: LazyDBA.com Discussion
Subject: dbms output problem..


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