PL/SQL: select in other schema does'nt work ?

why does a select statement like 'Select * from scott.emp' not work in a

plsql procedure created & owned by a user granded with dba rights ?

If the same stament is used in a sql session there is no problem, but when i try to compile the procedure, the table in the other schema is not recognized, also if a table synonym is used.

Please can anybody tell me whats going wrong ? Thanks ! Received on Mon Apr 26 1999 - 08:29:12 CDT