I am working on Oracle 9i.
When executing the dbms_output part, the following error is being returned:
ORA-20000: ORU-10028: line length overflow, limit of 255 chars per line
This is the code being executed
-- write to clob
xmldom.writeToClob(mydomdocument,myclobvar);
dbms_output.put_line(myclobvar);
I have tried using the commands
SET SERVEROUTPUT ON size '1000000'
and
DBMS_OUTPUT.ENABLE(1000000)
but still the same error (ORA-20000) was returned.
Any ideas on how I can output my DOM document (mydomdocument) without getting the same errors?
Thanks.