One test type that we encounter often and currently struggle with in code tester involves the following steps
- Load sample data to input tables
- Run package (MAIN PACKAGE) that uses the data in input tables & generates data in output tables
- Compare output tables to expected results
Currently, the approach we have taken is to write a wrapper procedure for step 1 & 2 and write unit tests on the wrapper package. While this works, it ends up creating a several additional wrapper procedures for each variant of input data.
Is there a cleaner way to do this with code tester?