Toad World® Forums

how to test local procedures/functions inside package body


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 ?



You can’t execute ‘private’ procedures defined in package body from outside of package by default. So you can’t test it by this way. You can execute and test what is declared in the package specification only.