Overview of TableReport PSP Sample
----------------------------------------
This Sample describes how to create a Table Report application using PSPs.
The PSP application provides an interface to allow the user to select a Table,
Columns, Enter a WHERE condition and generate the Report.

Note : This PSP sample application supports only those Column Data Types
            supported by the 'SELECT' SQL statement.

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

  1) Invoke the application by opening the TableReport page. This will display all the User Tables.

  2) Select a Table and press the 'Show Columns' button, All the Columns in the Table are displayed.

  3) Select the Columns required to be displayed in the Report or Alternatively the 'Select All' / 'DeSelect All'
      buttons can also be used and press the 'Create Query' button.

  4) (Optional) Enter the 'WHERE' condition required for restricting the Query.
      Press the 'Generate Report' button which generates the Final Table Report as required.

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 Table Report PSPs in the Oracle Database
    2) Readme.html                 - This file
    3) TableReport.psp          - Main page of the application displays the various frames.
    4) Title.psp                       - Displays the Title of the application in the main page.
    5) Tables.psp                    - Displays list of all the tables owned by the database user.
    6) TabBut.psp                  - Displays the button to view the columns of the Table selected.
    7) TabRep.psp                 - Displays the list of columns in the selected Table.
    8) ColBut.psp                   - Displays the options for creating the query.
    9) CreateQuery.psp          - Displays the Form for entering the where condition and generates the report.
  10) Error_Page.psp            - Error page of the application.
 

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

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

     Step 1. Install the PSPs 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.104:7890/pls/sample/tablereport