| Alert [message #80219] |
Mon, 26 August 2002 08:08  |
asma
Messages: 12
Registered: December 2000
|
Junior Member |
|
|
I have an alert , I need to dispaly message and along with the message I need to
display the update by user and updated date.
These values are in the table and they are not dispalyed in the block.
how do I display the data from the table in the alert?
Thanks
|
|
|
|
| Re: Alert [message #80240 is a reply to message #80219] |
Wed, 28 August 2002 10:14  |
bobh
Messages: 3
Registered: August 2002
|
Junior Member |
|
|
DECLARE
alert_id ALERT := Find_Alert('generic_alert');
dummy_var NUMBER;
alert_msg varchar2(80);
BEGIN
-- select table values e.g. into vtalbeuser and
-- vtabledate
-- and put them in your
-- alert message
alert_msg := 'Updated by: ' || vtableuser ||
' on ' || vtabledate
Set_Alert_Property(alert_id, ALERT_MESSAGE_TEXT, alert_msg);
-- now show the alert
dummy_var := Show_Alert(alert_id);
END;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
