ORA-00942 when logging errors with DBMS_ERRLOG tables.
609545Jun 5 2009 — edited Jun 5 2009Hello. I've a schema A, which contains tables I want to log errors on using the DBMS_ERRLOG package.
So, created these in schema B, explicitly specifying that the owner of these error tables should be schema B. This works fine.
I've also a package in schema B, which updates a table in schema A. This table has an error logging table associated with it.
When I try to compile the package, I get : PL/SQL: ORA-00942: table or view does not exist
The problem is the usage of "LOG ERRORS REJECT LIMIT 10000" at the end of my update statement. Removing it allows the package to compile.
Usually when I see ORA-00942: I know this is usually a privs/grant issue, but in this case, the schema which compiling the package and the schema which owns the error tables are the same. Can anyone see where I'm going wrong?
Many thanks,
Ray