title: Print CLOB content out as is in Oracle SQL script
body: <p>To start with here is the bigger picture of the task I'm trying to do. I need to create a xml file from the results of the particular SQL request and store it in a file on the client computer. For that I have a SQL script that does the DBMS_XMLGen with xslt, which I'm going to run from a command line with sqlplus and pipe the output into a file.</p>
  
  <p>The problem I'm having now is that content of the XML code (stored in CLOB) has to be splitted into smaller chunks for DBMS_OUTPUT.PUT_LINE, and every chunk ends up with a new line character, breaking the structure of the XML code. I wonder if there's a way to print the content of a BLOB as is on the screen?</p>
  
  <p>Here's the example of the SQL script:</p>
  
  <pre>
  SET SERVEROUTPUT ON FORMAT WRAPPED;
  set feedback off
  DECLARE
   v_ctx   DBMS_XMLGen.ctxHandle;
   v_xml   CLOB;
   v_xslt  CLOB;
   l_offset number := 1;
  BEGIN
    v_ctx := DBMS_XMLGen.newContext('SELECT * FROM TABLE');
  
  --  DBMS_XMLGen.setXSLT(v_ctx, v_xslt); --not relevant here
  
    v_xml := BMS_XMLGen(v_ctx);
    DBMS_XMLGen.closeContext(v_ctx);
  
    loop exit when l_offset > dbms_lob.getlength(v_xml);
     DBMS_OUTPUT.PUT_LINE (dbms_lob.substr( v_xml, 255, l_offset));
     l_offset := l_offset + 255;
    end loop;
  
  
  EXCEPTION
    WHEN OTHERS THEN
      DBMS_OUTPUT.PUT_LINE(Substr(SQLERRM,1,255));
   raise;
  END;
  /
  </pre>
  
  <p>The output I'm getting is correct apart from the new line character after every 255 symbols. And I can't just remove the end of lines later, I need the XML to be readable</p>
  
  <p>Any ideas?</p>
  
  <p>Cheers,
  Leo</p>