Dequeueing propagted message using PL/SQL notification
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;
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;
0