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 ...

Get Oracle E-Business Suite R12 Core Development and Extension Cookbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.