Each DBMS_OUTPUT.PUT_LINE has a limit of 255 characters. If you have more
then you have to have another statement.
Regards
Amin Adatia ([Email address protected]
KnowTech Solutions Inc. (www.knowtech.ca)
(613) 226-8378 Mobile (613) 864-8378
----- Original Message -----
From: "Brian Winter "
<oracledba-ezmlmshield-x20870424.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Friday, December 28, 2007 1:00 PM
Subject: RE: length overflow DBMS_OUTPUT
> Set long n;
>
> is an sql command to set a parameter in your SQL*Plus environment.
>
> SQL*Plus by default only shows the first 80 bytes of any LONG, CLOB and
> NCLOB datatypes. This command allows you to display more.
>
> Nothing to do with dbms_output afaik.
>
> -----Original Message-----
> From: Manash Baruah
> [mailto:oracledba-ezmlmshield-x3509994.[Email address protected]
> Sent: 28 December 2007 16:26
> To: LazyDBA Discussion
> Subject: RE: length overflow DBMS_OUTPUT
>
>
> To increase the length you have to use:
>
> Set LONG n;
>
> Where n=100, 200 etc...
>
>
> Thanks & Regards,
>
> Manash Partim Baruah
> Collaboration Platform LCS-E-commerce| DBA Team| Tech Mahindra Ltd.|
> Sharda Center, 6th Floor Annex Building, Pune-4, India
> www.techmahindra.com
>
>
> -----Original Message-----
> From: Brian Winter
> [mailto:oracledba-ezmlmshield-x88384424.[Email address protected]
> Sent: Friday, December 28, 2007 9:06 PM
> 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
>
>
>
> ============================================================================
> ================================================
>
>
> Disclaimer:
>
> This message and the information contained herein is proprietary and
> confidential and subject to the Tech Mahindra policy statement, you may
> review the policy at <a
> href="http://www.techmahindra.com/Disclaimer.html">http://www.techmahindra.c
> om/Disclaimer.html</a> externally and <a
> href="http://tim.techmahindra.com/Disclaimer.html">http://tim.techmahindra.c
> om/Disclaimer.html</a> internally within Tech Mahindra.
>
> ============================================================================
> ================================================
>
>
> ---------------------------------------------------------------------
> 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