ORA-20000: ORU-10028: line length overflow, limit of 255 bytes per line & buffer over
ORA-20000: ORU-10028: line length overflow, limit of 255 bytes per line
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.
[Edited by orareddy on 06-04-2002 at 01:25 PM]
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.
If you really need it try this:
VAR NUMBER := 1;
WHILE VAR <= LENGTH(RESULTS) LOOP
DBMS_OUTPUT.PUT_LINE(SUBSTR(RESULTS, I, 200));
I = I + 200;
Click Here to Expand Forum to Full Width