Maybe I'm out of it to long, but I believe in prior to 10g that 255 was
the limit on the length of a line. The serveroutput, or 'enable' is
for the entire buffer.

You might notice that if you are in a loop and dbms_output a line each
iteration, that the entire stored procedure or anonomous block will
finish completely before you see any output on the screen. This is
because it is all being saved in the buffer, and the buffer is emptied
when the procedure is done.

10g I believe has increased the bytes per line, and not sure what
'unlimited' is.... ('unlimited' might be quite a bit smaller than
infinity)?

Joel Patterson
Database Administrator
joel.[Email address protected]
x72546
904 727-2546

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