Advanced Queuing: remote enqueuing/dequeuing

From: AleX <korrozia_at_my-deja.com>
Date: Tue, 10 Aug 1999 05:58:41 GMT
Message-ID: <7oof2d$nng$1@nnrp1.deja.com>

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. Received on Tue Aug 10 1999 - 00:58:41 CDT