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: 230

Filed under:
|
|

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

Related posts about Oracle

Related posts about sql