Incorrect Code Analysis Validation on Package Specifications (4242598)

Incorrect Code Analysis Validation on Package Specifications

When you have a Team Project with the Code Analysis option enabled, Toad validates the code during the Check Out and Check In process to compare the metrics for the "Prevent check-in on metrics lower than check-out" option. During the Check In, Code Analysis compares the "Server Copy" with a "Local Copy".

This seems to work fine for all objects (procedures, functions) but just not for the Package Spec.

If you perform a Check In on a Package, Code Analysis first analyzes the Specification, but doesn't seem to find the correct - or any metrics for the "Server Copy".

All the metrics are set to "1", and it compares the best ratings with the Local Copy - as a result, every status fails.

After that, Code Analysis validates the Package Body and that works correctly, the "Server Copy" metrics are the ones Code Analysis stored during Check Out. It appears to only be an issue if a package has two objects - the Spec and the Body.

WORKAROUND:
Issue resolved in Toad beta version 13.1, available here

STATUS:
Waiting for fix in a future release of Toad for Oracle

TOR-2830