Expiring AdHoc roles from Post Notification function
Our workflow creates an AdHoc role and assigns users to it for a notification.
The notification has a function attached to it, and it calls
SETADHOCROLEEXPIRATION(adHocRoleName, NULL);
in funcmode='RUN'. That code is being called (according to the debugger) but the Role is still visible in the Workflow web app, and has no expiration date in the LOCAL_ROLES table.
I assume that calling that function like that should:
1: Set the expiration date
2: Make the Role not appear in the web app.
What am I missing.
BTW
I've tried adding a "commit" immediately after setting the expiration (despite the WF docs "... never commit within the PL/SQL procedure of a function activity.") with no apparent effect.
Does a post notification function NOT fall under this classification?
Thanks,