Propagate message to a particular database queue
Dear all
I have three test databases MYDB, PLDB, and MYSITE in the same server. I have queue in each database and propagation schedule from database MYDB to PLDB and MYDB to MYSITE. When I am using the following PL/SQL to enqueue the message in MYSITE the message get propagated to all (MYSITE and PLDB) database successful
DECLARE
enqueue_options DBMS_AQ.ENQUEUE_OPTIONS_T;
message_properties DBMS_AQ.MESSAGE_PROPERTIES_T;
message_handle RAW(16);
message strmadmin.mydb_rtgs_tp;
BEGIN
message := strmadmin.mydb_rtgs_tp(
data => 'Test Hello'
);
DBMS_AQ.ENQUEUE(
queue_name =>'strmadmin.mydb_rtgs_qu',
enqueue_options => enqueue_options,