Table or view does not exist - ONLY in Procedure?
527623Aug 28 2009 — edited Aug 28 2009I'm trying to write a procedure that is very simple - the only thing at this point I'm trying to get it to do is an insert into a table - values selected from another user's schema (on which I have select privileges to). When compiling, I receive an ORA-942 error - table or view does not exist. However, if I put the same insert statement into an anonymous PL/SQL block, it works as expected. What am I missing?
Oracle 10.2.0.3.0 on AIX 5.3