Create a Custom Program in Oracle DMW

You can define a custom program directly in Oracle DMW by accessing Programs from the Navigation menu.

1. ClickNavigation 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 custom program.
3. Select Custom Program 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 custom program.
   • 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 program. The page refreshes with additional fields so you can complete the program. The custom program is automatically checked out so you can continue editing any details.
   • Click Save & add another to save the information of the current program and begin entering the basic information of another custom program. The background page refreshes to display your newly-created program 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 continue creating your program in the following sections:
   • Source and Target tables: Define your table descriptors under a domain, application area, or data model by clicking Add Table. A sidebar displays on the right of the page that allows you to search and filter domains and data models as well as select whether the table descriptor is a Source or Target.

     Alternately, you can click Upload Table to create a table descriptor from a .mdd file.

   • Source Code Reference: If the program you are creating (primary source code) needs to invoke any static references (secondary source code), you can search existing packages and select them in this section. Click Save to include the selected static reference(s) in your program.
   • Source Code: In the Shareable drop down menu, select Yes to make the source code available for reuse.

     Then, enter a Package Name and Procedure Name in the respective fields.

     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 program. Alternately, you can write the source code directly in the text box.

     Click Compile Source Code to check the program for any errors.

     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.

6. If you are finished adding or editing the details of your custom program, you can click the Check in button below the Program details section at the top of the page.