On 10g try
set serveroutput on size unlimited



-----Original Message-----
From: Brian Winter
[mailto:oracledba-ezmlmshield-x88384424.[Email address protected]
Sent: Friday, December 28, 2007 10:36 AM
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



Oracle LazyDBA home page