Dynamic Alert Message in Oracle Forms.

Introduction:

The Alert Message need to be changed at run time based on the condition criteria.

Cause of the issue:

In Oracle Forms, we have a standard functionality to create a Alert with a single message and buttons. But we user requested to display the different alert message at run time based on the criteria that matches.

How do we solve:

The below is the Property to create or change a alert message using SET_ALERT_PROPERTY and Buttons label using SET_ALERT_BUTTON_PROPERTY during run time.

Script:

DECLARE

p_value   NUMBER;

BEGIN

p_value := 120;

SET_ALERT_BUTTON_PROPERTY (‘alert_name’, alert_button1, label, ‘Yes’);

SET_ALERT_BUTTON_PROPERTY (‘alert_name’, alert_button2, label, ‘No’);

SET_ALERT_PROPERTY (‘alert_name’,

alert_message_text,

‘Do you want continue value Exceeds’ || p_value || ‘?’

);

n := SHOW_ALERT (‘alert_name’);

IF n = alert_button1

THEN

:sel_button := ‘You choose Yes to Continue’;

ELSE

:sel_button := ‘You choose NO to Stop’;

END IF;

END;

Recent Posts

Start typing and press Enter to search