oracle sql developer is truncating my results
        Posted  
        
            by nont
        on Stack Overflow
        
        See other posts from Stack Overflow
        
            or by nont
        
        
        
        Published on 2010-04-08T19:10:30Z
        Indexed on 
            2010/04/08
            19:13 UTC
        
        
        Read the original article
        Hit count: 269
        
I'm calling a stored function like this:
select XML_INVOICE.GENERATE_XML_DOC('84200006823') from dual;
The query results then show up in a table underneath, which I can right click and select "Export Date" -> XML
<?xml version='1.0'  encoding='UTF8' ?>
<RESULTS>
  <ROW>
    <COLUMN NAME="XML_INVOICE.GENERATE_XML_DOC('84200006823')" <![CDATA[<xml>yada yada</xml><morexml>...]]></COLUMN>
  </ROW>
</RESULTS>
The problem is the "..." - SQL Developer (2.1.0.63 on Linux) is not showing all the data - its truncating the result and appending the ellipsis. This is of no use to me. How do I get it to export ALL of my data?
© Stack Overflow or respective owner