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 );