Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

dbms_aq.purge queue table related

543174Oct 31 2006 — edited Nov 21 2006
Could 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 !!!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 19 2006
Added on Oct 31 2006
10 comments
5,393 views