dbms_aq.purge queue table related
543174Oct 31 2006 — edited Nov 21 2006Could you please help me on this.
I have created a queue added a subsriber with rule to dequeue only priority=3 messages.registered for automatic notifications. When I enqueued , messages successfully dequeued.
Then I ran the following code to purge the table
declare
po dbms_aqadm.aq$_purge_options_t;
Begin
po.block := FALSE;
DBMS_AQADM.PURGE_QUEUE_TABLE
(QUEUE_TABLE => 'request' ,
purge_condition => NULL ,
purge_options => po);
END;
It ran successfully and cleared all messages from the table.
Now ,when I try to enqueue a message got following error
ORA-25455: evaluation error for rule set: AQ.REQUEST_R, evaluation context: AQ.AQ$_REQUEST_TABLE_V
ORA-01410: invalid ROWID
ORA-06512: at "SYS.DBMS_AQ", line 168
Could you please explain , why I am getting this.
Also kindly let me know, where the subscriber rules will be stored and is there way to retrieve them.
Thanking You in advance !!!