Original post can't be 10gR2 (although might be 10gR1? - not tested). In
10gR2 lower limit of range is 2000, and won't go down to 255 afaik.

I think I am right in saying that in 10gR1 and earlier dbms_output.put_line
has an imposed limit of 255 chars. That is not to say that the buffer
cannot be larger - it can - set in sql by " set serveroutput on size nnn",
or in pl/sql by dbms_output.enable(nnn) as shown below. This is used to
hold multiple lines before output is displayed at the end of the procedure.

In 10gR2 this limit is lifted to 32k, same as similar UTL_FILE procedures.

I believe the answer to the original post is "You can't if you are using
version 10gR1 or less"
bw

-----Original Message-----
From: Gaurav Shrivastava
[mailto:oracledba-ezmlmshield-x70410054.[Email address protected]
Sent: 28 December 2007 15:39
To: LazyDBA Discussion
Subject: RE: length overflow DBMS_OUTPUT

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





Oracle LazyDBA home page