title: How to make a select from a cursor that returns from a plsql function ORACLE
body: <p>i have a function that return a cursor my package is like this</p>
  
  <p><code>FUNCTION SEDIRUNTIME (sede varchar2) return SYS_REFCURSOR</code></p>
  
  <p>this cursor return x number of row with only one value, for example :</p>
  
  <pre><code> ROW1 - 34
   ROW2 - 55
   ROW3 - 56  ecc. ecc.
  </code></pre>
  
  <p>now i have i select like this </p>
  
  <pre><code>.. AND field in  (select DBK_ENIN_REPORT.*SEDIRUNTIME*(sede) from dual)
  </code></pre>
  
  <p>this will simulate a clause <strong><em>IN</em></strong> which we can know the values at run time.</p>
  
  <p>for example, based on the location parameter, the cursor can give me 22 and 34 rather than just 56 or 78 98 09.</p>
  
  <p>written so i do not work from error number 00932 incoherent data types.</p>
  
  <p>solutions?</p>