oracle sql developer is truncating my results

Question

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 Data" -> 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?

Answer 1

I was having the same issue in SQL Developer 4. Here is what worked for me:

set long 100000;
set longchunksize 100000;

And then re-run the query. You should now be able to see the full cell in the grid view and export it to csv as well.

(The OP is no longer with the same job or using Oracle, but this question is one of the first results in google, so hopefully this will help people having the same problem.)