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