In this post I will describe how to send mail from an Oracle
Form using GMAIL SMTP over SSL. I conducted the test on Windows Server 2008 x64
with Oracle Forms 10g. To be quite frank, this is nothing new, but it might be
of use anyway.
Preface
I wanted to send emails from my Form designed on oracle form
builder. It was not a corporate solution with access to an internal smtp-host.
A simple, accessible, ISP agnostic smtp-server would do. In my case, Gmail
fitted the bill, only problem was that Gmail required SSL, which UTL_SMTP does
not support. I am up for a challenge, so here goes...
Pre-requisite:
Make sure mailsend package is downloaded and gmail account
is created with complete access as described in my earlier post.
Link 1 Direct Link 2,
Open it in oracle form builder change the credentials in WHEN-NEW-FORM-INSTANCE Trigger. Now compile and run.
8 comments:
sir mail send k forms pary hain ap ka pass
Download Package is available on this post.
How to send any file with email, please guide.
Please send me full program of sending emails from oracle forms 11g ( fmb)
Download Package is available on this post. you can compile it in 11g
TNX Hasan BRO PLZ.. Help How to Send include attachments..
THANK U HASAN
PLEASE HOW CAN I SEND EMAIL WITH ARABIC SUBJECT
nice sir you are very genius.
Post a Comment