You can't. DBMS_OUTPUT.ENABLE(200000) does not affect line length, and will
do nothing to fix Shadab's reported errors.

I posted on this subject three days ago so I won't repeat myself here.
bw

-----Original Message-----
From: Pitchai Siva (GE Infra Energy Non-GE)
[mailto:oracledba-ezmlmshield-x91049331.[Email address protected]
Sent: 31 December 2007 10:28
To: LazyDBA Discussion
Subject: RE: length overflow DBMS_OUTPUT

For avoid this error you can increase DBMS_OUTPUT buffer size so you can
use DBMS_OUTPUT.ENABLE(200000)


Regards,
Siva.P
Bangalore. India
"You never achieve real success unless you like what you are doing"


-----Original Message-----
From: Nagarajan VinodhKumar
[mailto:oracledba-ezmlmshield-x6873105.[Email address protected]
Sent: Monday, December 31, 2007 3:41 PM
To: LazyDBA Discussion
Subject: RE: length overflow DBMS_OUTPUT

For this error, you should restrict the amount of data you are passing
to the buffer in a single call to PUT_LINE, or in a batch of calls to
PUT followed by NEW_LINE.


try this



Thanks & Regards

Vinodh Kumar N K,
Oracle SOG practice,
Syntel inc,
>Consider IT Done
N<0441-3109>
M<+91-9944764877>
E<vinodhkumar_nagarajan @syntelinc.com>


-----Original Message-----
From: Shadab Mehboob
[mailto:oracledba-ezmlmshield-x20806821.[Email address protected]
Sent: Friday, December 28, 2007 5:29 PM
To: LazyDBA Discussion
Subject: length overflow DBMS_OUTPUT


Dear Masters
I have an error wheni display the output and the error message is as
shown below

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 337


How do i increase the limit beyond 255 .
Kindly help
Regards
Shadab


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Confidential: This electronic message and all contents contain
information from Syntel, Inc. which may be privileged, confidential or
otherwise protected from disclosure. The information is intended to be
for the addressee only. If you are not the addressee, any disclosure,
copy, distribution or use of the contents of this message is prohibited.
If you have received this electronic message in error, please notify the
sender immediately and destroy the original message and all copies.


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




Oracle LazyDBA home page