I am using a separate schema for each application. XXG_CODE_TESTER is the test schema and APPS is the code schema. I have granted execute priv on the package i am changing to xxg_Code_tester. The test seems to be working fine but I am only able to select the public procedure in package spec for creating and running the test.
Is it possible to test local procedures/functions in the package body ?