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