Thursday, December 12, 2019

Oracle Forms Working with Alert

DECLARE
v_alert VARCHAR2(10);
v_name VARCHAR2(20);
BEGIN
v_name := :ALERT.name;
set_alert_property ('NOTE', title, 'Save Alert');
set_alert_property ('NOTE', alert_message_text, 'This is your Name :- '||v_name);
v_alert := SHOW_ALERT ('NOTE');
END;