-
Advanced Queuing
Hi All,
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?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|