Required Software
-------------------
1.   Oracle Database Server Version 8.1.6 or higher
2.   Oracle Internet Application Server(iAS) Version 1.0 or higher
3.   OracleXML SQL Utility.
4.   Oracle 8i Travel Schema downloadable from OTN Site.
        - http://technet.oracle.com/
5.   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. Install OracleXML SQL utility into the database.

                 Oracle XDK for Java utility(XSU12_ver1_2_1.zip) is downloadable from
                 http://technet.oracle.com/ site on the web. Carefully follow the instructs to
                 load the utility into the database.

                 For the benefit of the members, the installation steps is as follows.
                 Step 1: After dowloading the file to a local directory, unzip the file. Edit env.bat under the directory
                             into which you unzipped  (Ex: C:\[your unzipped directory]) to change the PD environment
                             variable.
                             (Ex: rem set PD=C:\downloads\OracleXSU%JDBCVER%
                                    set PD=C:\OracleXSU12\OracleXSU%JDBCVER%)
                             Save and execute the file.
                 Step 2: Edit oraclexmlsqlload.bat file under (Ex: C:\[your unzipped directory]/lib) directory.
                             Change the following line by providing username/password@connectstring
                             Ex: set USER_PASSWORD="travel/travel@<dbalias>"
                             Save and execute the batch file.

    Step 4. Extracting and Loading XMHotelInfo PSP Application.

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

            b) Extract the XMLHotelInfo.zip file in this directory

            c) After extracting the .zip file,it creates 'XMLHotelInfo' directory which contains the source files
                of the application.

            d) Load all psps in the 'XMLHotelInfo' directory using the 'loadpsp' utility supplied
                with iAS software. This utility can be found under the directory $IAS_HOME/bin. Add
                this directory to the System Path. Then, from the XMLHotelInfo directory, run the following
                command to load the page:

               loadpsp -replace -user <uname>/<passwd>@<dbalias> SqlToXml.psp *.psp

               where,
                      <uname>/<passwd> - is the username/password of schema where the psp has to be loaded
                                                        (here it will be the Travel schema - travel/travel)
                      <dbalias>                 - is the sql*net tns names alias to connect to the desired database
                                                        (here the database is the one in which Travel schema is installed)