I have a package that I want to clean up. I know there are variables in it that are not being used and I want to find them. Is there anything in Toad that will find these variables for me?
1) Load the package into the Editor.
2) If it is not already open, open the Codexpert window. You can do this by right clicking in the Editor window, selecting Desktop Panels, and then selecting CodeXpert.
3) Click the button on the far left of the Codexpert toolbar. It has a red and green arrow and is called "Perform a code quality review of the editor contents"
4) Once completed running, expand the Program Structure node and then the Variables Node.
5) The variables you are looking for will be listed under "Avoid defining variables that are not referenced inside the program."
