title: Returning a single large clob from a restful service in Oracle APEX
body: <p>Is there any way to return a clob as text (or file) without splitting into smaller pieces first?</p>
  <p>I tried creating a <code>GET</code> handler with <code>PL/SQL</code> source that would just do this:</p>
  <pre class="lang-sql prettyprint-override"><code>declare
    txt clob;
  begin
    ...-- set clob
    htp.p(txt);
  end;
  </code></pre>
  <p>But then I was getting the error <code>ORA-06502: PL/SQL: numeric or value error</code>.</p>
  <p>I then tried cutting the clob in smaller segments and calling <code>htp.p</code> multiple times, which worked, but I was wondering if there was a way to send the whole thing in one go.</p>