title: Oracle: creating value set with query
body: <p>I have a query which returns a list of values:</p>
  
  <pre><code>WITH temp AS (
      SELECT 108 Name, 'Err1, Err2, Err3' Error FROM DUAL
      UNION ALL
      SELECT 109, 'Err4' FROM DUAL
  )
  SELECT distinct Name,
      TRIM(REGEXP_SUBSTR(str, '[^,]+', 1, LEVEL)) str
  FROM (SELECT Name, Error str FROM temp) t
  CONNECT BY INSTR(str, ',', 1, LEVEL - 1) &gt; 0
  ORDER BY Name;
  </code></pre>
  
  <p><img src="https://i.stack.imgur.com/bj8NC.png" alt="enter image description here"></p>
  
  <p>I would like to create a value set (Err1, Err2, Err3, Err4) for parameter to be used in oracle concurrent program. However, the validation type 'Table' does not allow to insert such complicated query as shown above. </p>
  
  <p><img src="https://i.stack.imgur.com/4ivFA.png" alt="enter image description here"></p>
  
  <p>Is there any way to do so?</p>