Home » SQL & PL/SQL » SQL & PL/SQL » ORA-20000: ORU-10028: line length overflow, limit of 255 chars per line
ORA-20000: ORU-10028: line length overflow, limit of 255 chars per line [message #116282] Tue, 19 April 2005 03:22 Go to next message
shooter
Messages: 44
Registered: February 2005
Member
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.

Re: ORA-20000: ORU-10028: line length overflow, limit of 255 chars per line [message #116310 is a reply to message #116282] Tue, 19 April 2005 06:44 Go to previous message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
You can't with dbms_output. The lines are limited to 255 characters. Look at this thread from Tom Kyte for an alternative.

[EDIT: Corrected URL]
MHE

[Updated on: Tue, 19 April 2005 06:44]

Report message to a moderator

Previous Topic: how to multiple things at a time?
Next Topic: Query to Synonyms names
Goto Forum:
  


Current Time: Thu Jul 24 04:13:39 CDT 2025