Have you tried using PRINT in SQL*Plus? Here's an example:

var LONG_STRING CLOB;
begin
:LONG_STRING := 'someStringLessThan_60,000_characters';
end;
/
SET LONG 1000000
SET LONGCHUNKSIZE 1000000

COLUMN LONG_STRING FORMAT A60000

PRINT LONG_STRING
Todd Pepling
[Email address protected]
724-766-3492

________________________________

From: Shadab Mehboob [mailto:oracledba-ezmlmshield-x90745028.[Email address protected]
Sent: Sat 12/29/2007 1:47
To: LazyDBA Discussion
Subject: Re: length overflow DBMS_OUTPUT



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 <http://jobs.lazydba.com/> To Subscribe : http://www.LazyDBA.com <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 <http://jobs.lazydba.com/>
> To Subscribe : http://www.LazyDBA.com <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 <http://jobs.lazydba.com/>
To Subscribe : http://www.LazyDBA.com <http://www.lazydba.com/>
To unsubscribe: http://www.lazydba.com/unsubscribe.html





Oracle LazyDBA home page