Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

Send email from procedure in forms 4.5

H.T.S
Occasional Visitor

Send email from procedure in forms 4.5

I need to create procedure for sending email using Oracle forms 4.5
I have tried using OLE but it gives error in using it in the procedure.
and I have tried also using SMTP but it does not work and does not give an error through compiling, but it gives exception ora-29279 in running.
Can any one help me please?!
If I can't create procedure for sending emails in forms 4.5 and need oracle 8i please tell me to update my database
Thnx all.
H.T.S
2 REPLIES
Steven E. Protter
Exalted Contributor

Re: Send email from procedure in forms 4.5

Shalom HTS

Oracle probaly is unaware of where the sendmail binary is. There is probably a configuration file where the actual location needs to be set.

If you look at the smtp log /var/adm/syslog/mail.log you may see errors that will help you with Oracle configuration.

Otherwise refer to the Oracle docs and setup the oracle environment variables in the forms 4.5 startup script.

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
H.T.S
Occasional Visitor

Re: Send email from procedure in forms 4.5

Dear SEP,
Can u descuss for me how can I send emails using forms 4.5, besause I didn't find the SMTP log file that you talked about.
Thnx alot and I am waiting ur reply.
HTS