Dear PRaven
i am afraid the statement didnt work . The output is still the same and the
error of teh limit is still there.
I believe it increases the buffer size not the line length.

Regards
Shadab
----- Original Message -----
From: "Pravin Subramanian "
<oracledba-ezmlmshield-x17643206.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Friday, December 28, 2007 5:42 PM
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