Instructions for Creating the Objects


To create the account that will own the database objects you need to perform the following actions:

1.     Download the script CREATE_OBJECTS.SQL and save it in your environment, for example in the folder C:\ORAFORMS_BOOK\SQL.

2.     Obtain access to the Oracle Server instance where you created the account that will own these objects.

3.     Start SQL*Plus and connect to the Oracle Server instance.

4.     At the SQL prompt type START <path>\CREATE_OBJECTS.SQL and press ENTER. Here, <path> is the location where you saved the file CREATE_OBJECTS.SQL. For example:

               START C:\ORAFORMS_BOOK\SQL\CREATE_OBJECTS.SQL

5.     Provide the name of the name of the account that will own the objects.

6.     Provide the password for this account when prompted.

7.     Provide the database name or connection string when prompted.

At this point, the script creates the new objects and populates them with the necessary data to run the applications discussed in the book.