07Jul
By: Marc Ruel On: July 7, 2021 In: Instant Tips Comments: 0

In this Tip: How to improve your APEX process success messages to give your users more precise feedback.

 

The following is the code that Hayden used to demonstrate assigning values to “g_success_print_message”
declare

l_message varchar2(1000);

begin

   ait.run_process (p_param   => :P3_PARAM,

                    p_param2  => :P3_PARAM2,

                    p_num     => :P3_NUM,

                    p_message => l_message);

 

 case when l_message is not null

       then apex_application.g_print_success_message := apex_application.g_print_success_message ||

                                                        case when apex_application.g_print_success_message is not null

                                                            then '<br/>'

                                                        end ||

                                                        l_message;

       else null;

  end case;

end;

Insum's APEX Instant Tips: Every Friday at 12:05pm EST

Join Anton and Hayden every Friday at 12:05pm EST live on our Facebook and YouTube channels, as they present a new APEX tip every week.

Subscribe and hit the bell to be notified so you never miss a thing!

View Past Episodes

Full episode list on YouTube here.

Share this:
Share

Leave reply:

Your email address will not be published.