title: Oracle extract from xml truncating value
body: <p>We have a CLOB column where we're storing fairly simple XML, from which I need to extract the property of one of the tags.  I believe the select statement is correct, since I get a portion of the value, but it's truncating it at 80 characters.</p>
  
  <p>Here's a snippet of the XML...</p>
  
  <pre><code>&lt;?xml version="1.0" encoding="UTF-8"?&gt;
  &lt;service_orders count="1"&gt;
     &lt;service_order order_number="fakefakefake" id="fakefakefake"&gt;
        &lt;customer&gt;
           &lt;customer_id&gt;ABCDE12346&lt;/customer_id&gt;
           &lt;first_name&gt;FAKE&lt;/first_name&gt;
           &lt;last_name&gt;CUSTOMER&lt;/last_name&gt;
        &lt;/customer&gt;
  ...
      &lt;images count="2"&gt;
         &lt;image src="https://s3.amazonaws.com/some_subfolder/deeper/deeper_still/ever_deeper/really_big_long_url_goes_here" thumbnail="https://s3.amazonaws.com/some_subfolder/deeper/deeper_still/ever_deeper/really_big_long_url_goes_here_thumb"/&gt;
  &lt;/images&gt;
  ...
  </code></pre>
  
  <p>...and here's a snippet of the SQL...</p>
  
  <pre><code>select
      xmltype(contact_data).extract('/service_order/@order_number').getStringVal ordnum
     ,extract(xmltype(contact_data) ,'//images/image/@src') imgsrc
  from
      my_table
  where
      trunc(contact_date) = trunc(sysdate)
  and extractvalue(xmltype(contact_data) ,'/service_order/@order_number') = '&amp;ordnum'
  </code></pre>
  
  <p>The beginning of the URL returns but, as previously stated, the URL is truncated at 80 characters.</p>
  
  <p>What am I doing wrong?</p>