To increase the length you have to use:

Set LONG n;

Where n=100, 200 etc...


Thanks & Regards,

Manash Partim Baruah
Collaboration Platform LCS-E-commerce| DBA Team| Tech Mahindra Ltd.|
Sharda Center, 6th Floor Annex Building, Pune-4, India
www.techmahindra.com


-----Original Message-----
From: Brian Winter
[mailto:oracledba-ezmlmshield-x88384424.[Email address protected]
Sent: Friday, December 28, 2007 9:06 PM
To: LazyDBA Discussion
Subject: RE: length overflow DBMS_OUTPUT

Interesting. Does that increase line length too?
I'll be using that in future then, rather than split long output over
multiple lines as I have been doing ...
Thank you

-----Original Message-----
From: Pravin Subramanian
[mailto:oracledba-ezmlmshield-x17643206.[Email address protected]
Sent: 28 December 2007 12:12
To: LazyDBA Discussion
Subject: RE: length overflow DBMS_OUTPUT

Dear Shadab,

Try using this statement

execute dbms_output.enable(2000000)

Where the argument to enable() is the buffer size you need.

Regards,

Pravin

-----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








---
This e-mail message may contain confidential, proprietary or legally
privileged information. It should not be used by anyone who is not the
original intended recipient.If you have erroneously received this
message, please delete it immediately and notify the sender. The
recipient acknowledges that 3i Infotech or its subsidiaries and
associated companies, (collectively "3i Infotech"), are unable to
exercise control or ensure or guarantee the integrity of/over the
contents of the information contained in e-mail transmissions and
further acknowledges that any views expressed in this message are those
of the individual sender and no binding nature of the message shall be
implied or assumed unless the sender does so expressly with due
authority of 3i Infotech. Before opening any attachments please check
them for viruses and defects.



---------------------------------------------------------------------
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



============================================================================================================================


Disclaimer:

This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy statement, you may review the policy at <a href="http://www.techmahindra.com/Disclaimer.html">http://www.techmahindra.com/Disclaimer.html</a> externally and <a href="http://tim.techmahindra.com/Disclaimer.html">http://tim.techmahindra.com/Disclaimer.html</a> internally within Tech Mahindra.

============================================================================================================================

Oracle LazyDBA home page