APEX Instant Tip #32 Better Success Messages

07Jul

APEX Instant Tip #32 Better Success Messages

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;