Is there a way to access private plsql procedures for testing purposes?

Viewed 2994

I'm working on a project with a lot of plsql code and would like to add more specific unit-tests to our codebase. Some of the procedures/functions I like to test aren't in the package spec and I have no means to change that.

Is there a way to access these 'private' plsql procedures without adding them to the spec?

The only Idea I had so far, was to compile a special package spec to the DB before the tests, that specifies the procedures under test. I gues that would work, but I wonder if there is a simpler way, some evil secret oracle hack maybe ;-)

I'm testing from Java with JUnit/DBUnit.

BR Frank

4 Answers
Related