title: sqlplus report - XML data being truncated
body: <p>I am running a query that returns XML data and spools to a file. I'm having a problem where the output of the query is being truncated. Here's what it looks like:</p>
  
  <pre><code>XMLDATA                                          
  ----------------------------------------         
  &lt;?xml version="1.0" standalone="yes"?&gt;           
  &lt;msgs&gt;                                           
    &lt;msg&gt;                                          
      &lt;PNUM&gt;ABC12345                       
  </code></pre>
  
  <p>What I am expection was something like this:</p>
  
  <pre><code>XMLDATA                                          
  ----------------------------------------         
  &lt;?xml version="1.0" standalone="yes"?&gt;           
  &lt;msgs&gt;                                           
    &lt;msg&gt;                                          
      &lt;PNUM&gt;ABC1234567&lt;/PNUM&gt;
      &lt;MSG_ID&gt;1234&lt;/MSG_ID&gt;
      &lt;NAME&gt;Test message&lt;/NAME&gt;
      &lt;TEXT&gt;This is the main content of the message&lt;/TEXT&gt;
    &lt;/msg&gt;
    &lt;!-- about 60 other msg elements --&gt;
  &lt;/msgs&gt;
  </code></pre>
  
  <p>The <code>select</code> statement is simple enough:</p>
  
  <pre><code>select xmlroot(xmlelement("msgs",xmlagg(xmlelement("msg",xmlforest(PNUM , MSG_ID , NAME, TEXT)))), VERSION '1.0', STANDALONE YES) xmldata
  from ...
  </code></pre>
  
  <p>I am guessing there's some sqlplus formatting trick here, I just don't know which one (or even what it's called).</p>
  
  <p>(Oracle version is 10g)</p>