Create a Static Function in Oracle DMW

You can make a static function that can be included in custom programs in Oracle DMW by accessing Programs from the Navigation button on the toolbar.

1. Click Navigation from the toolbar. Select Programs from the context menu.
2. Click the Add button.
   A sidebar appears on the right of the screen, allowing you to input basic information about the new static function.
3. Select Static Function from the Select Type drop down menu and then complete the following fields:
   • Select Location: Select an existing location from this drop down menu or click Add button, which opens a window where you can create a new location.
   • Program Name: Enter a name for the new static function.
   • Description: Add a description of the program (optional).
   • Select Tech Type: Choose PLSQL or SAS Program from the drop down menu.
4. Select one of the following buttons:
   • Click Save & add source to save the information you have added so far and continue working on this static function. The page refreshes with additional fields so you can complete the function. The static function is automatically checked out so you can continue editing any details.
   • Click Save & add another to save the information of the current function and begin entering the basic information of another static function. The background page refreshes to display your newly-created function in the grid and the Add Program sidebar clears so you can enter the details of a new program.
5. After clicking Save & add source, you can add the source code of your function.
6. If you've already written your source code in a .txt or .sql file, you can use the Upload Source Code button to add the source code to the static function. Alternately, you can write the source code directly in the text box.
7. Click Compile Source Code to check the program for any errors.
8. Click Save Source Code to save the source code and its details. The code is also compiled at this point and will alert you to any errors found.
9. If you are finished adding or editing the details of your static, you can click the Check in button at the bottom of the Program details section at the top of the page.
10. If the static function is both checked in and has been successfully promoted to the Production lifecycle, you can install it by clicking the Install button. Alternately, you can install the static function from the Custom Programs & Static Functions main page after selecting the static function from the grid.