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



Oracle LazyDBA home page