Wednesday, 4 August 2010

Rule Set "Applsys.Wf_deferred_r" Has Errors

After upgraded database from 10.2.0.4 to 11.2.0, Rule Set WF_DEFERRED_R  became invalid

To implement the solution, please execute the following steps:

1. Run that PL/SQL

sqlplus applsys/
declare
lagent sys.aq$_agent;
subscriber_exist exception;
pragma EXCEPTION_INIT(subscriber_exist, -24034);
begin
lagent := sys.aq$_agent('WF_DEFERRED',null,0);
dbms_aqadm.add_subscriber(queue_name=>'APPLSYS.WF_DEFERRED',subscriber=>lagent,rule=>'1=1');
exception
when subscriber_exist then
-- just add the rule if subscriber exists
dbms_aqadm.alter_subscriber(queue_name=>'APPLSYS.WF_DEFERRED',subscriber=>lagent,rule=>'1=1');
end;
/

Cheers!!!

SocialTwist Tell-a-Friend

Related Posts by Categories



1 comment:

Amandeep said...

Spot on!!

It fixed the similar error when we upgraded database from 10.2.0.3 to 10.2.0.4 on hp-ux 64-bit platform.