Sending automatic email confirmation 1

[Meryl]

I have created an application using developer/2000 that will allow users to enter data online. I have created a submit button. When submitted, it enables data to be written on different tables. I then created a "success page" that informs the user that they have successfully submitted the data. I would like to send an email confirmation that would say "Thank you for using our Online Reporting System to submit your Company's data. This email serves to acknowledge that we have received your submission." I created the email address field. The user should get the acknowledgement letter if they enter the email address and submit the data. Is there a way for me to incorporate this when the user 'submits' data along with the email address?

I am using developer/2000 5.0.6.14.2 and Database server version 8.0.5.1.0 on a Windows NT 4.0 server. Our email server is GroupWise.

I don't have much experience with email confirmations, so any suggestions would be greatly appreciated.

Thanks a lot,

Meryl

 

[uparna]

Hi ,
There is no mention of what platform you are using to create the pages. In case you are using jsp ,then i can send over the example of the email-sending java program. You can get in touch with me at oracguru@yahoo.com in case this is what you need.

Regards,
Jayaram.

 

[Meryl]

This post does not help, because i don't use jsp. Please help me with any other suggestions.

 

[MikeJones]

8.0.5 eh? That a real shame, If you could get the server upgrades to 8.1.6 then Oracle supplies a package called dbms_smtp that would fill your requirements very nicely. But you on 8.0.5.

Many moons ago before Oracle grasped that sending emails from the DB would be useful I implemented the following solution, it was for Unix, so I'm assuming that you can create services on the NT server that will be able to

Connect to the DB
Perform a Query
Perform an Update
Send an email automatically.

As I said, I wrote this for Unix, which can do this tuff, I'm not a NT man.

The basic principle was when you need to send an email you insert a row into a table detailing all you need to send the email and a "processed" y/n flag.

You then have a process on the server which polls this table looking for unprocessed rows, it queries these rows back, set the rows to completed and then sends the emails as needed.

Unfortunatly I have no idea how to implement this on NT.

Maybe you should push for that 8.1.6 upgrade.

BTW, the is a FAQ on this.