procedure SetAdHocRoleStatus (role_name in varchar2, status in varchar2 default 'ACTIVE');
Sets the status of an ad hoc role as 'ACTIVE' or 'INACTIVE'.
| role_name | The internal name of the role. |
| status | A status of 'ACTIVE' or 'INACTIVE' to set for the role. If null, the status is 'ACTIVE'. |