title: How to use varchar2 variable in XMLTable function?
body: <p>I am trying to use XMLTable function as follow,</p>
  
  <pre><code>DECLARE IDs VARCHAR2(2000);
  
  IDs := '4013105,4013106,4013107,4013108,4013109';
  
  SELECT TO_NUMBER(COLUMN_VALUE) FROM XMLTABLE(:TRACT_IDS);
  </code></pre>
  
  <p>but getting this error</p>
  
  <blockquote>
    <p>PL/SQL: ORA-19102: XQuery string literal expected</p>
  </blockquote>
  
  <p>If I use XMLTable with following example it runs successfully,</p>
  
  <pre><code>SELECT TO_NUMBER(COLUMN_VALUE) FROM XMLTABLE('4013105,4013106,4013107,4013108,4013109');
  </code></pre>
  
  <p>Please help in this regard..</p>