Print a success Message on Page in Dynamic Action
nscglrMay 31 2012 — edited Jun 11 2012Hi guys,
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
)
AS
BEGIN
update .......;
COMMIT;
apex_application.g_print_success_message := '<span style="color:red">Alarm processed successfully.</span>';
EXCEPTION
WHEN OTHERS
THEN
ROLLBACK;
RAISE;
END processAlarm;
/
Do you have any idea how can I do this?
Thanks.