c. In the DA's "Page Items to Return" enter P1_FOR_DA_HDDN
--apex_application.g_print_success_message := 'Alarm processed successfully.'; apex_util.set_session_state('P1_FOR_DA_HDDN', TO_CHAR(SYSTIMESTAMP) ); -- SYSTIMESTAMP is only to force a change in the item every time the process is run. Alternate to using null/not null or other values.
nscglr wrote:This PL/SQl global variable will only be useful when the page is rendering and it will not change the message once the page is rendered.
I have a dynamic action that executes a pl/sql code block. I need to display a message when this procedure is completed. I tried several options like using "apex_application.g_print_success_message" but I couldn't achieve this. Here is my plsql code :
CREATE OR REPLACE PROCEDURE processAlrm
p_alarmAction IN VARCHAR2
,p_alarmID IN VARCHAR2
apex_application.g_print_success_message := '<span style="color:red">Alarm processed successfully.</span>';
EXCEPTIONWhat happens if there is any error?
END processAlarm;In your Execute PL/SQL Code set the checkbox stop execution on error
Do you have any idea how can I do this?