plsql - pl/sql: stored procedure table or view does not exist -

i have 2 tables customer , order same tablespace.

if select * cutomer.date left join order.date b on a.id = b.id, work fine.

if create stored procedure like:

create or replace procedure aproc(prc out sys_refcursor) begin open prc select * cutomer.date left join order.date b on a.id = b.id; end aproc; 

it cause error:

table or view not exist.

if change procedure name aproc customer.aproc, order cause table not exist error.

i tried authid current_user, doesn't work.

is there way can both tables?

i've solved problem adjusting levels of packages, thank attention anyways