Re: Executing AQ procedure via DB link

per333_at_my-deja.com wrote in <8vg3r6$9gg$1_at_nnrp1.deja.com>:

>Hi,
>
>Is it possible to execute the DBMS_AQ procedures via a DB link? I have
>two databases (called NGB and CID) and I have a queue on the NGB
>database. I would like to dequeue the queue from the CID database, i.e.
>have a procedure on the CID that calls the DBMS_AQ.DEQUEUE procedure on
>the NGB. Is it possible? I don't know how!!
>
>I have tried:
>
>DBMS_AQ.DEQUEUE(queue_name => 'test_poa_Q',
> dequeue_options => v_DequeueOptions,
> message_properties => v_MessageProperties,
> payload => v_Message,
> msgid => v_MsgID)@NGB;
>
>...but it doesn't work.
>Any suggestions?
>
>Thnx
>// POA
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
>

If I'm not mistaken, the syntax for a remote packaged procedure call is:

            package.procedure_at_dblink(parameters)

i.e. move @NGB in front of the right paren. Received on Wed Nov 22 2000 - 14:34:19 CST