Compiling a Function

If you edit and make changes to a function, you need to compile in order to save your changes. There is no save function because this is just a view of the object within the database.

To compile a function in Object Browser:

1. On the Workspace home page, click SQL Workshop and then Object Browser.

   Object Browser appears.

2. From the Object list, select Functions.

3. From the Object Selection pane, select a function.

   The Code view appears.

4. Click Compile to compile the current function.

   Compiling re-creates the object in the database. If the compile fails, an error message display above the code.