How to Check your current consumers
select *
from
APPS.AQ$_WF_BPEL_QTAB_S
How to Delete a WF_BPEL consumer
DECLARE
subscriber sys.aq$_agent;
begin subscriber := sys.aq$_agent('<CONSUMER_NAME>', NULL, NULL);
dbms_aqadm.remove_subscriber(queue_name => 'WF_BPEL_Q', subscriber => subscriber);
end;
No comments:
Post a Comment