Oracle E-Business Suite R12 Core Development and Extension Cookbook

Installing the database objects

Create the database objects for this chapter before you start by using a script provided called 4842_02_01.sh. We are going to create a table, a view, and a synonym for the new block we will create. 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 records. The following recipe 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\ch2 where the scripts are downloaded and extracted to.
2. Open Putty and connect to the application tier ...