Test package compilation error when attempting to compare custom defined collections (4236603)

Test package compilation error when attempting to compare custom defined collections

When attempting to compare the contents of an associative array (defined as a package level variable) with an associative array defined in Code Tester, the package does not compile.

In Code Tester it's possible to reference the associative array as an expression in the Outcomes tab. You can also able to enter the expected data set. However, when you attempt to execute the test, the test package fails to compile.

The assertion code generated by Code Testers attempts to call a function that is not declared anywhere in the test package.

Product defect

WORKAROUND:
1. Download the attached script TO_UPGRADE_DATA.sql to a folder.
2. Connect Toad for Oracle to the Code Tester repository schema and run this script.
3. Regenerate every test definition having the problem (testing global variable of collection, record or object type) using the "Generate Test Code" button from the main toll box.
4. Run the problematic test definitions and make sure your results are correct.

STATUS:
Fixed in Code Tester for Oracle v2.7

CTO-256

The issue is due to be fixed in v2.7