Home » RDBMS Server » Server Administration » DBMS_OUTPUT
DBMS_OUTPUT [message #370588] Mon, 03 January 2000 18:07 Go to next message
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 Go to previous message
Messages: 10
Registered: January 2000
Location: Glendale, AZ
Junior Member

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


Previous Topic: help me
Next Topic: Query a few rows in one
Goto Forum:

Current Time: Sat Oct 31 19:31:38 CDT 2020