title: Why does the SYS_REFCURSOR results in a null value?
body: <p>Table CKSFLTHD</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>FILTERC</th>
  <th>DESCR</th>
  <th>ACTIVATE</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>ABC</td>
  <td>Apple Bees Corner</td>
  <td>1</td>
  </tr>
  <tr>
  <td>EFG</td>
  <td>Elephant Forest Grove</td>
  <td>1</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Table CKSFLTLN</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>FILTERC</th>
  <th>SITE</th>
  <th>LNUM</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>ABC</td>
  <td>Apple Bees Corner</td>
  <td>ABC123</td>
  </tr>
  <tr>
  <td>EFG</td>
  <td>Elephant Forest Grove</td>
  <td>EFG456</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>This is what the output should look like, but a null table instead.
  I'm going to use the <strong>DISPLAY</strong> to populate a dropdownlist.</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>DISPLAY</th>
  <th>DATAVAL</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>Apple Bees Corner</td>
  <td>ABC</td>
  </tr>
  </tbody>
  </table>
  </div>
  <pre><code>OPEN  cv_2 FOR 
    SELECT descr DispVal, filterc DataVal
    FROM cksflthd
    WHERE activate = 1
    AND ( v_showAll = 1
    OR filterc IN ( SELECT *
                    FROM ( SELECT DISTINCT filterc
                           FROM cksfltln
                           WHERE  SITE IN ( SELECT SITE
                                            FROM cksfltln
                                            WHERE  filterc = v_userfiltercode )
  
                           AND ( lnum &lt;&gt; ' '
                                 OR filterc = v_userfiltercode ) ) useflt
                          
                    WHERE  filterc IN ( SELECT DISTINCT filterc  
                                        FROM cksfltln
                                        WHERE  SITE IN ( SELECT SITE
                                                         FROM cksfltln
                                                         WHERE  filterc = v_filterCode )
  
                                        AND ( lnum &lt;&gt; ' '
                                              OR filterc = v_filterCode ) )
                         )
                    );
  </code></pre>