From within the procedure editor a procedure can be compiled by selecting the menu option Compile > Compile or by clicking the Compile icon. If the procedure compiles successfully, a window appears confirming a successful compile. If the compile fails, then error message comments are inserted into the procedure code. In the following example, the error messages are in color red and begin with -E-.

Error comments is inserted at each error point. A compile will delete any previous error comments. Error comments can also be removed through the menu option Compile > Delete Error messages.

Note

In some instances, the error comments may not be positioned on the correct line. This can occur as the result of one or more procedure lines being wrapped. Therefore, ensure the procedure editor window is maximized when dealing with compile errors. 

If a procedure fails to compile then it is invalidated in the database and will not run until successfully compiled.

  • No labels