ORA-942 when compiling wrapped package - how to identify the problem table


alter session set events '942 trace name errorstack level 1';

alter package xxxx compile body;

A trace file will then be generated - right at the end you should see

----- Java Stack -----
about to signal 942
Name: OBJECT_NAME_HERE

Comments