When executing a batch optimize on a .XML file:
1. From Batch List, right-click and select "Add Jobs | Source Code".
2. Select a .XML file with embedded SQL code.
3. After batch optimize is completed, click on 'Job Report' and Toad will generate the following error
The following unhandled error has occurred
Collection was modified; enumeration
operation may not execute
4. Clicking on OK gave the following error and SQL Optimizer disappears.
Quest.Tuning.Oracle.Main has encountered a problem and needs to close.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center