title: ORA-00942: table or view does not exist (works when a separate sql, but does not work inside a oracle function)
body: <p>When I have a sql statement like <code>select * from table1</code>, it works great, but as soon as I put it into a function, I get:</p>
  
  <pre><code>ORA-00942: table or view does not exist 
  </code></pre>
  
  <p>How to solve this?</p>