Overview of Send Email PSP Sample
--------------------------------------
This Sample describes how to create a simple Send Email application
using PSPs.
The PSP application provides an interface to input the Email information
like sender
and receipient address and message text. Upon pressing the Send Email
button the
email will be sent using the UTL_SMTP PL/SQL package. Before the email
is sent,
the inputs are validated. An error message is displayed if any of the
inputs are not
entered or invalid.
When the email is successfully sent a success message is displayed to the user.
Steps in the Sample :
---------------------
1) Invoke the application by opening the Mail_Input page. This
will display the interface
to accept the inputs for the Email to
be sent.
2) Please enter the sender and receipient addresses and the message
text and press the
Send Email button. The message will
then be sent to the receipient address and a
message is diaplyed to the user.
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:
a) Install.html
- The steps to install the Send Email PSPs in the Oracle Database
b) Readme.html
- This file
c) Source Files of Sample - Mail_Input.psp, Send_Email.psp,
Sm_Error_Page.psp
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.104:7890/pls/sample/mail_input