procedure Directory
(end_date in date default sysdate,
orig_system in varchar2 default null,
autocommit in boolean default false);
Purges all ad hoc users and roles in the WF_LOCAL_ROLES and WF_LOCAL_USER_ROLES tables whose expiration date is less than or equal to the specified end date and that are not referenced in any notification.
Note that although ad hoc users and roles whose expiration date has passed do not appear in the seeded WF_USERS, WF_ROLES, and WF_USER_ROLES views, they are not removed from the Workflow local tables until you purge them using Directory(). You should periodically purge expired ad hoc users and roles in order to improve performance.
Note: This API does not delete ad hoc users or roles whose expiration date is null. To ensure that ad hoc users and roles are purged in a timely fashion after they are no longer needed, estimate how long they should be active and specify an appropriate expiration date when you call WF_DIRECTORY.CreateAdHocUser(), WF_DIRECTORY.CreateAdHocRole(), or WF_DIRECTORY.CreateAdHocRole2() to create them.
| end_date | Date to purge to. |
| orig_system | Optionally specify an originating system to purge only ad hoc users and roles associated with that system. |
| autocommit | Specify TRUE or FALSE to indicate whether to commit data while purging. If you want Directory() to commit data as it purges to reduce rollback size and improve performance, specify TRUE. If you do not want to perform automatic commits, specify FALSE. Defaults to FALSE. |