U can try using UTL_FILE package. You can't pass in the string which has got
more than 255 characters to DBMS_OUTPUT function.


Vikrant J.

-----Original Message-----
From: Prabhakaran, K [mailto:K.[Email Address Removed] Friday, March 01, 2002 10:24 AM
To: LazyDBA.com Discussion
Subject: dbms output problem..


ERROR at line 1:
ORA-20000: ORU-10028: line length overflow, limit of 255 bytes per line
ORA-06512: at "SYS.DBMS_OUTPUT", line 84
ORA-06512: at "SYS.DBMS_OUTPUT", line 58
ORA-06512: at line 2

i got the above error when i tried to display a line which has more than
1000 letters altogether in a single dbms_outpu.put_line function call.
is there anyway that we can overcome this!

ur's help would be greatly appreciated,
Prabhakar

--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html

Oracle LazyDBA home page