title: Oracle 'identifier myschema.mytable must be declared'
body: <p>Trying to run some sql in a pl/sql procedure.  </p>
  
  <p>Select field from schema.view;</p>
  
  <p>I get a compile error </p>
  
  <p>Error(22,18): PLS-00201: identifier 'schema.view' must be declared</p>
  
  <p>From the error, it seems that my user does not have access to the table.  I can run the same statement in a query window.  </p>
  
  <p>Is there a permission I need to grant?</p>
  
  <p>Thanks!</p>