FORMS [message #80032] |
Sun, 04 August 2002 23:09 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
nazar
Messages: 5 Registered: August 2002
|
Junior Member |
|
|
1. Can we set Forms to refresh the record itself, let say after every 30 seconds during runtime to see any changes to the record? If possible, how to do it in details.
2. How to set automatic Outlook/SMS alert message in Oracle Forms whenever any condition is violated? The purpose is to automatically generate sms/outlook messages to prompt support people for any error round the clock.
|
|
|
Re: FORMS [message #80034 is a reply to message #80032] |
Mon, 05 August 2002 00:08 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Subhash
Messages: 105 Registered: October 2001
|
Senior Member |
|
|
1. Create a timer which expires in every 30 seconds.In the 'When_Timer_Expired' triger write code for clearing the block and fecthing the data again.
2. Use UTL_SMTP
|
|
|
Re: FORMS [message #80037 is a reply to message #80032] |
Mon, 05 August 2002 19:03 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
nazar
Messages: 5 Registered: August 2002
|
Junior Member |
|
|
Managed to do the timer but it keeps on going back to first record in database instead of currently viewed record everytime it refresh.
For the sms, what trigger to fire to enable sms to be sent automatically whenever the any condition is violated.
|
|
|