DBMS_OUTPUT [message #370588] |
Mon, 03 January 2000 18:07 |
bin
Messages: 4 Registered: December 1999
|
Junior Member |
|
|
Can anybody tell me how to output a string(e.g. 400 bytes), which is more than 255 bytes ,in one line.
when I try this dbms_outp(string1||','||string2);
(assume string1 and string2 are 200 bytes each)
There is an error:
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 13
thank you
|
|
|
Re: DBMS_OUTPUT [message #370614 is a reply to message #370588] |
Thu, 06 January 2000 17:33 |
|
jaramill
Messages: 10 Registered: January 2000 Location: Glendale, AZ
|
Junior Member |
|
|
Bin:
I tried to figure out your problem but couldn't do it. Then while searching the web I came across someone's website that had built a free utility that does EXACTLY what you want to do. Here's there link at the bottom. Go check it out. The file is called SYSUTILS.ZIP
Gio
|
|
|