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: 15
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...

Report message to a moderator

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: 21807
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.

Report message to a moderator

Previous Topic: Query find form
Next Topic: Key mapping
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 16 06:09:35 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.