Home » Developer & Programmer » Forms » How to get updated item name and its value on oracle forms 10g (Oracle forms 10g)
How to get updated item name and its value on oracle forms 10g [message #619819] Fri, 25 July 2014 04:19 Go to next message
Rockstar
Messages: 12
Registered: January 2012
Location: Udaipur
Junior Member
Dear all,
I have a requirement such that once a record has been created and now user want to update any item on form then on every update of record a mail to be send to execution team that these field has been changed by the user after post query...
how can i get the name and values of updated field after post query.....
pls suggest...
Re: How to get updated item name and its value on oracle forms 10g [message #619820 is a reply to message #619819] Fri, 25 July 2014 04:38 Go to previous message
Littlefoot
Messages: 19610
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I'd use a database trigger. It is capable of logging changes (you can store previous values into another table so that you'd know which column was changed, as well as its previous and current value). It can also send an e-mail (UTL_SMTP).

Now that you know the keywords, research them.
Previous Topic: Query find form
Next Topic: Key mapping
Goto Forum:
  


Current Time: Thu Sep 18 17:14:26 CDT 2014

Total time taken to generate the page: 0.19496 seconds