Getdbdatetime PSP Sample
------------------------------------

Overview of Getdbdatetime PSP Sample
-----------------------------------------
This Sample describes how to create a basic PSP application.
The PSP application creates a simple HTML page and displays the Database Date and Time value in it.

Steps in the Sample :
---------------------

Invoke the application Getdbdatetime, a HTML page is displayed with the Database Date and Time.

Description of Sample Files :
-----------------------------
The sample is provided as a zip file. This zip file contains all the files required for the sample.
It contains the following files:

    1) Install.html                    - The steps to install the Getdbdatetime PSP in the Oracle Database
    2) Readme.html                 - This file
    3) GetDBDateTime.psp   - This psp file displays the database date and time.

The steps in running the sample in iAS environment is explained below :

Running the sample using Oracle iAS:
--------------------------------------

     Step 1. Install the PSP onto the Oracle database using the instructions in the Install.html

     Step 2. On the Application Server machine where iAS is installed, create a Database
                 Access Descriptor(DAD) to connect to the schema where the PSP is installed
                 in Step 1.

                 Note: For details on creating DADs, refer to the document "Using mod_plsql"
                          on the Documentation Library CD-ROM of iAS software.

     Step 3. After creating the DAD, access the page by using a URL like:
                 http://<ipaddress>:<Port>/<virtual_path>/<dadname>/<PL/SQL procedure name>
                 where,
                     <ipaddress>      -> is the ip-address of the machine on which iAS is setup
                     <Port>              -> is the port on which iAS http listener is setup to run
                                                  (refer to file $IAS_HOME/Apache/Apache/conf/httpds.conf)
                     <virtual_path>   -> is the prefix defined for the PL/SQL module
                                                  (refer to file $IAS_HOME/Apache/modplsql/cfg/plsql.conf)
                     <dadname>       -> is the name of the DAD created in Step 2.

             Example:
             http://152.69.168.209:7890/pls/sample/getdbdatetime