Oracle E-Business Suite R12 Core Development and Extension Cookbook

Creating a HOST concurrent program

In this recipe, we are going to create two concurrent programs. The first concurrent program will call the second concurrent program through PL/SQL. The first concurrent program will also generate a file and place it in a directory on the database server. The second concurrent program will call a host program that will get the file we just created and will e-mail it to an e-mail account. To complete the recipe we will perform the following tasks:

• Creating a PL/SQL executable
• Configuring a concurrent program to call the PL/SQL executable
• Creating a HOST executable
• Configuring a concurrent program to call the HOST executable
• Adding concurrent programs to a menu
• Creating an OUT directory
• Creating a symbolic link
• Testing ...