title: Oracle 12c: use JSON_QUERY in a trigger
body: <p>I have a CLOB Json in a column of a table with the following structure:</p>
  <pre><code>{&quot;sources&quot;: [1,2,4]}
  </code></pre>
  <p>I'm trying to write a trigger that read the array [1,2,4] and performs some checks:</p>
  <p>I'm trying using:</p>
  <pre><code>DECLARE
  TYPE source_type IS TABLE OF NUMBER;
  SOURCES source_type;
  [...]
  json_query(:NEW.COL, '$.sources') BULK COLLECT INTO SOURCES FROM dual;
  </code></pre>
  <p>but I got the error:</p>
  <pre><code>Row 1: ORA-01722: invalid number
  </code></pre>
  <p>Any ideas?</p>