| FORMS [message #80032] |
Sun, 04 August 2002 23:09  |
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  |
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 |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
