Oracle E-Business Suite R12 Core Development and Extension Cookbook

Installing the database objects

We are going to create the database objects for the next examples, by using a script provided called 4842_01_01.sh In the next examples we will be configuring a concurrent program that calls a host program. The script we are going to run will create a sequence, synonym, and package for our host program call. We will also create a package that will handle all of the database transactions such as insert, update, and delete. Finally, we will create a sequence that will be used to generate a unique number for new filenames. The following provides details of how to run the script.

How to do it...

To create the database objects required for this chapter perform the following tasks:

1. Create a local directory c:\packt\scripts\ch1 ...