I want to trigger an inline notification using Dynamic action when a hidden item is updated via PLSQL Process.
This is the code of the Process:
declare
l_success boolean;
BEGIN
l_success := myfin.authentication_pkg.activate_new_user(:P0_USER_ID, :P99990_USERNAME, :P99990_ACCESS_TOKEN);
if l_success = false then
:P99990_ALERT := 'something went wrong';
end if;
END;
I created a DA, on change of P99990_ALERT.
This DA does not get triggered. It seems like the PLSQL does not trigger change event. How can I achieve that?
My goal is to show inline notifications (success, warning, error) via the DA.