Hi,
I am trying to output a large CLOB.
DECLARE
v_text CLOB;
BEGIN
dbms_output.enable(NULL);
v_text := HTML_TEMPLATE.parse(43,21);
dbms_output.put_line(dbms_lob.getlength(v_text));
END;
Then I get:
41503
As the length of v_text.
I would like to output the full content of v_text. How can I achieve that? I have seen some tips here and here, but they are not working and when I try any of them I getting the following error:
ORA-20000: ORU-10027: buffer overflow, limit of 20000 bytes
This is the whole code I am using, where print_clob is the procedure posted here:
DECLARE
v_text CLOB;
BEGIN
dbms_output.enable(NULL);
v_text := HTML_TEMPLATE.parse(43,21);
dbms_output.put_line(dbms_lob.getlength(v_text));
HTML_TEMPLATE.print_clob(v_text);
END;
I am using Oracle 11g R2 XE.
Any help is welcomed