Thursday, January 6, 2022

How to create alerts in oracle forms



First Step: 

you need to Create alert 

How to create alerts in oracle forms

Second Step: 
Name of alert is “ERRMSG”
Alert Style = “Caution”
Button 1 Label = “OK”

How to create alerts in oracle forms


Third Step:
Create Procedure
Procedure Name = “Call_alt”

How to create alerts in oracle forms


Fourth Step:

Paste that code in the Procedure


PROCEDURE call_alt (msg in varchar2)IS

  alt number;

BEGIN

       Set_Alert_Property('errmsg', alert_message_text,msg );

       alt := show_alert('errmsg');

END;


How to create alerts in oracle forms

Fifth Step:

Call this procedure from any trigger you show the message just pass the message.

In my case:

I created Button and use this trigger on “WHEN-BUTTON-PRESSED”

How to create alerts in oracle forms
How to create alerts in oracle forms
Output:

How to create alerts in oracle forms


I hope it's helpful for you. If you have any queries, don't hesitate to contact me.

Name : Muhammad Sahal Qasim
E-mail : s.m.sahal789@gmail.com
Thank you.


0 comments:

Post a Comment

If you have any doubts, please let me know. I will help you.