forms -alert [message #587658] |
Mon, 17 June 2013 15:27 |
|
thelearner
Messages: 133 Registered: April 2013 Location: INDIA
|
Senior Member |
|
|
Hi,
In alters I want to display a value dynamically.
like when deptno=10 came then it should dynamically displays the message like Department 10''.
when deptno=20 came then it should dynamically displays the message like Department 20''.
and.....
Thanks & Regards,
The Learner.
[Updated on: Mon, 17 June 2013 15:28] Report message to a moderator
|
|
|
|
|
|
Re: forms -alert [message #589146 is a reply to message #588083] |
Tue, 02 July 2013 13:13 |
|
thelearner
Messages: 133 Registered: April 2013 Location: INDIA
|
Senior Member |
|
|
Finally i got the alert......
declare
alrt varchar2(20);
alrt2 varchar2(30):='You Selected Department No: '||:EMP.deptno;
begin
set_alert_property('ALERT1',ALERT_MESSAGE_TEXT,alrt2);
alrt:=show_alert('ALERT1');
END;
|
|
|