Required Software
-------------------
1.   Oracle Database Server Version 8.1.6 or higher
2.   Oracle Internet Application Server(iAS) Version 1.0 or higher
3.   Oracle PL/SQL Web Toolkit Packages :
               The Schema in which the PSPs are to be loaded should have access to the
               Web Toolkit packages supplied by Oracle. For instructions on installing
               these packages and giving access, refer to the Chapter 'Installing mod_PLSQL'
               - Section 'Installing required packages' in document "Using mod_plsql" on the
               Documentation Library CD-ROM of iAS software.

Preliminary Installation Steps for installing PSPs in Oracle Database
---------------------------------------------------------------------
    Step 1. Install Oracle iAS and setup the http server using the
                instructions in the manual supplied with the software

    Step 2. Update your SYSTEM path to include the $IAS_HOME/bin directory

    Step 3. This sample needs a Table to be created in the Database to work properly.
                To create this table, run the following create table command against a desired
                schema in an Oracle 8.1.6 database or higher:

                sqlplus > CREATE TABLE guestbook
                              (name                 VARCHAR2(50) NOT NULL,
                               email                  VARCHAR2(100) NOT NULL,
                               comments           LONG NOT NULL,
                               creation_date     DATE);

    Step 4. Extracting and Loading GuestBook PSP Application.

            a) Create a new directory <pspSamples> to hold the Sample .psp files

            b) Extract the GuestBook.zip file provided in this directory using winzip

            c) After extracting the .zip file, it creates GuestBook directory.

            d) Load the .psp files in the GuestBook directory using the 'loadpsp' utility supplied
                with iAS software. This can be found under the directory $IAS_HOME/bin. Add
                this directory to the system path. Then, from the GuestBook directory, run the
                following commands to load the pages:

               loadpsp -replace -user <uname>/<passwd>@<dbalias> Guest_Book.psp View_GuestBook.psp
               loadpsp -replace -user <uname>/<passwd>@<dbalias> Gb_Error_Page.psp Submit_Comments.psp

               where,
                      <uname>/<passwd> - is the username/password of schema where the psp has to be loaded
                                                        (here the schema should be the same as the one used in
                                                        Step 2 to create the table)
                      <dbalias>                 - is the sql*net tns names alias to connect to the desired database