The menu option Validate > Validate Procedure Status compares procedures as stored in the metadata with those compiled and running in the data warehouse. This option provides a listing in the middle pane of each selected procedure and its status. The status will be Validates OK, Not compiled, or Compare failed.
Where a procedure is marked as Not compiled, this means that the procedure exists in the metadata but has not been compiled into the database.
Where a procedure fails to compare, the Procedure Editor must be used to find the actual differences. Start the editor by double-clicking the procedure object from the Objects list in the left pane. Use the Tools > Compare to Compiled Source menu option, to display the differences between the procedure in the metadata and that compiled in the database.