Hi there,
I hope someone can help on this one, and if you can,
please reply to rene_at_webhost.co.za
SCENARIO:
- We are running Oracle 8.0.4 on Sun Solaris 2.5.1
- The application is developed in PL/SQL procedures with built in HTML
for display on the web.
- The application allows a member-A of the system to send a message to
member-B. Then when Member-B logs in to the application he is notified
of this new message. In ohter words this in an "internal" system
message.
PROBLEM:
I would like for the application to ALSO send a SMTP-mail to Member-B,
at the same time that Member-A sends the internal message. ie. I want
Member-B to be notified via "normal" mail that a new message was sent to
him, and he should then log into the application to retrieve the message
that was sent to him from Member-A.
So the question is HOW do I manage this on ONE form-submit-page. Right
now the form-submit causes the message to be stored in an Oracle-table,
but I cannot see how I can ALSO cause this submit to kick off the SMTP
mail???
Of course I can kick off the SMTP-mail with a PERL script, but I cannot
call the perl-script as I would do a normal procedure call within
PL/SQL, which implies that a second button-click would be needed to be
clicked by Member-A, and I do not want to do this.
