-
ORA-20000: ORU-10028: line length overflow, limit of 255 bytes per line & buffer over
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]
-
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)
-
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;
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|