Re: Advanced Queuing: remote enqueuing/dequeuing

Alex

Enqueues are done locally. Propagation is used to get to the remote database.

HTH. Pete

AleX wrote:

> Hi!
>
> I have a simple but a very urgent question. I'm trying to enqueue a
> message from my local database with no queue to a remote database that
> has a queue. I have a dblink to that database. Oracle doesn't seem to be
> able to interpret this correctly:
>
> dbms_aq.enqueue(queue_name => 'aqadmin.queue2_at_wildfire',
> enqueue_options => enqueue_options,
> message_properties => message_properties,
> payload => message,
> msgid => message_handle);
>
> It complains that the queue name is invalid. Is it possible to remotely
> enqueue my message or do I need to user propogation?
>
> Thanx.
> --
> Alex Shterenberg
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.

--
Regards

Pete

Received on Tue Aug 10 1999 - 15:26:43 CDT