title: pl/sql: stored procedure table or view does not exist
body: <p>I have two tables CUSTOMER and ORDER from the same tablespace.</p>
  
  <p>If I do <code>select * from CUTOMER.date a left join ORDER.date b on a.id = b.id</code>, it will work fine.</p>
  
  <p>If I create a stored procedure like:</p>
  
  <pre><code>CREATE OR REPLACE PROCEDURE aProc(prc OUT Sys_Refcursor)
  AS
  BEGIN
  OPEN prc for select * from CUTOMER.date a left join ORDER.date b on a.id = b.id;
  END aProc;
  </code></pre>
  
  <p>It will cause error: </p>
  
  <blockquote>
    <p>Table or view does not exist.</p>
  </blockquote>
  
  <p>If I change the procedure name aProc to CUSTOMER.aProc, only ORDER will cause the table does not exist error.</p>
  
  <p>I also tried AUTHID CURRENT_USER, which doesn't work.</p>
  
  <p>Is there any way I can get both tables?</p>