Changing a Consumer Group
Within a Session
The user or the application can switch the current
consumer group.
DBMS_SESSION.
SWITCH_CURRENT_CONSUMER_GROUP (
new_consumer_group => 'DSS',
old_consumer_group => v_old_group,
initial_group_on_error => FALSE );