oracle sql developer is truncating my results
- by nont
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?
