Pure Performance Inc

During development things always change. Column names change, columns may be added or removed from tables and so on. When this happens, you need to go back to your PL/SQL programs and change the code. In some cases, you can just recompile the package or procedure to find the problems caused. But that doesn’t always catch everything, especially when you have dynamic SQL. So you should always run a PL/SQL search to find the column or text that has changed.