title: Invalid reference to named queries (WITH CLAUSE)
body: <p>The below is what I have</p>
  <pre><code>WITH T as 
  (SELECT columns 
  from table)
  select columns 
  from T 
  where recordid = 123
  and &lt;certain conditions met&gt;
  exception
  when no_data_found then
  select columns 
  from T
  where recordid = 123
  and &lt;some other conditions met&gt;
  
  </code></pre>
  <p>my requirement is to check for few conditions which if not met then i need to check for other conditions on the same record.</p>
  <p>without the exception block all works fine but when I use the exception block, it throws me an error that the defined query columns cannot be referenced in there</p>