GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Dequeueing propagted message using PL/SQL notification

edited Jan 2, 2014 7:24PM in GoldenGate, Streams and Distributed Database (MOSC) 3 commentsAnswered
Dear all
I want to dequeue messages using PL/SQL callback proceduare. The message is enqueued using propagation from another database. However the callback procedure is not fired when the message arrive in the queue. Using the same procedure when enqueueing a message locally execute the procedure


Here is my PL/SQL callback procedure:

CREATE OR REPLACE PROCEDURE strmadmin.dequeue_xmass_callback_proc(
                            context  RAW,
                            reginfo  SYS.AQ$_REG_INFO,
                            descr    SYS.AQ$_DESCRIPTOR,
                            payload  RAW,
                            payloadl NUMBER
                            )
AS
   dequeue_options     DBMS_AQ.DEQUEUE_OPTIONS_T;
   message_properties  DBMS_AQ.MESSAGE_PROPERTIES_T;
   message_handle      RAW(16);
   message             strmadmin.xmass_payload;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center