ORA-20000: ORU-10028: line length overflow, limit of 255 bytes per line

[orareddy]

Hi,

ORA-20000: ORU-10028: line length overflow, limit of 255 bytes per line

and also

ORA-20000: ORU-10027: buffer overflow,
limit of 20000 bytes


let me know how to fix the above error.

before executing the procedure.

i set the
set serveroutput on size(100000000);

when i am using DBMS_OUTPUT.PUTLINE(results);

i am getting error, the limit of 255 bytes per line and buffer overflow, limit of 20000 bytes.

thanks in advance.

Srinivas Reddy

[Edited by orareddy on 06-04-2002 at 01:25 PM]

[stecal]

The line size of a single line in the DBMS_OUTPUT buffer is limited to 255 characters. As such you must make sure that the line is terminated with an end-of-line marker before reaching this limit.

The end-of-line marker is written to the buffer using either the DBMS_OUTPUT.PUT_LINE or the BMS_OUTPUT.NEW_LINE procedure.

(From MetaLink)

[Highlander]

If you really need it try this:

DECLARE
VAR NUMBER := 1;
BEGIN
WHILE VAR <= LENGTH(RESULTS) LOOP
DBMS_OUTPUT.PUT_LINE(SUBSTR(RESULTS, I, 200));
I = I + 200;
END LOOP;
END;