The following is a list of issues resolved in this patch:
| Feature | Resolved Issue | Defect ID |
| Code Analysis | Rule 4801 was incorrectly triggering EXIT WHEN statements when it should only trigger IF THEN EXIT. | 100656 |
| Code Analysis | Rule 4804 was being triggered in a simple LOOP and should only be fired in FOR LOOP or WHILE LOOP statements. | 101515 |
| Code Analysis | Rule 6811 was being fired when the data type "double precision" was used. It should only fire for variables with spaces. | 100335 |
| Code Analysis | Rule 2129 was not triggering when more than 6 OR operations were used in a where clause. | 100335 |
| Code Analysis | Rule 5825 was being violated in a package that had only 1 insert statement for a table. This rule should only fire when there are multiple inserts. | 99750 |
| Code Analysis | Rule 2832 was being fired for all VARCHAR2 declarations. | 99750 |
| Code Analysis | Rule 6401: The same procedure name with different parameters in a package were being triggered. | N/A |
| Code Analysis | Rule 5406 was falsely triggering parameters as unused when they were used. | 99750 |
| Code Analysis | Rule 4809: Loops were being triggered even when using bulk and for all. | 99750 |
| Code Analysis | Rule 2118 was missing DDL such as trigger, function, and package objects. | N/A- |
| Code Analysis | Rule 5914: All transformations not in the database columns were being flagged, such as trun(sysdate) or nvl() function. | N/A |
| Code Analysis | Rule 5917 was falsely triggering select statements that did not contain a select *. This rule should only trigger "Insert into" statements that contain a select *. | 99750 |
| Code Analysis | Not all rule violations were getting inserted into the Database. Support Case ID: 1040377. | 100383 |
| Code Analysis | Code Analysis could not scan pl/sql objects that contained the keyword TABLE. Support Case ID: 1040377. | 1040377 |
| Team Coding | Code Collections Window did not always populate. Support Case ID: 1057039. | 102090 |
Please download the Hotfix, called Toad for Oracle 11.5.2 Patch for SOL95843 (ToadforOracle1152PatchFull_MSP.zip), by
NOTE: This patch is only applicable for Toad for Oracle 11.5 and 11.5.1. Please make sure that Toad for Oracle 11.5.x is installed before running this patch.
