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;
|
|
|