Procedures can be invalidated as a result of changes to underlying tables, or child procedures. A procedure can be recompiled through the procedure editor or via the menu option Tools > Compile Procedures:
The Compile Procedures window is displayed:
All procedures in the metadata can be compiled, or a selected group of procedures may be compiled. Selection is done via standard Windows multi selection, using the shift and CTRL keys. By selecting a project or group it is possible to compile all procedures associated with the project or group.
As each procedure is compiled, it is displayed in the middle pane of the Builder window. If a procedure fails to compile, a failure message is displayed along side the procedure name. Procedures that fail to compile will need to be investigated through the procedure editor, as no specific error information is provided by this bulk compiler.
Re-validate Procedures (Oracle only)
The menu option Tools > Re-compile Invalid Procedures will attempt to validate the procedure by issuing an 'alter procedure xxx compile' command. This command will be executed for any procedure or function that is in an invalid state in the schema. Any procedures or functions that are still invalid after the commands have been completed are shown in the results pane. WhereScape RED does not drop procedures from the database, even when their metadata is deleted. Therefore, there may be old procedures present that are in an invalid state. These procedures may be redundant.