Thursday, July 25, 2013

CHeck and remove WF_BPEL_Q consumers

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