I've implemented Advanced Queuing in Scott schema. I've enqueued one message by calling DBMS_AQ.ENQUEUE. The user which enqueued this message is 'SCOTT' (observed by inserting into a temporary table).
Now I've a PL/SQL callback procedure which will be called automatically to dequeue the message. In that procedure i have DBMS_AQ.DEQUEUE call to read the message. I've inserted the current user into the temporary table But here the user is 'SYS'.
So i would like to know whether we can dequeue the message using "SCOTT" user itself ?? can anyone help in solving this?
Click Here to Expand Forum to Full Width