Home » Developer & Programmer » Forms » URGENT: Auto mail a user on changing a field value
URGENT: Auto mail a user on changing a field value [message #229082] Thu, 05 April 2007 05:24 Go to next message
svik
Messages: 16
Registered: April 2005
Location: MRU
Junior Member
Hi to all,

In sqlforms 3.0.16.12.09 and database version 7.1.6.2.0, is it possible to add a trigger on a field, e.g date_left, so that whenever the user input a date in the field, a mail is automatically sent to another user. The mailing system is
SuSE Linux Openexchange Server CA.

Thanks for giving me an answer till tomorrow morning 06/04/2007.

Re: URGENT: Auto mail a user on changing a field value [message #230090 is a reply to message #229082] Tue, 10 April 2007 19:42 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Yes. Use DBMS_PIPE.

Search this SITE or google it.

David
Previous Topic: FRM:40735:POST-QUERY TRIGGER RAISED UNHANDLED EXCEPTION
Next Topic: TNS No Such Protocol adaptor Ora- 12222 and Unable to connect oracle :( (merged)
Goto Forum:
  


Current Time: Sun Aug 20 21:54:12 CDT 2017

Total time taken to generate the page: 0.01599 seconds