GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Propagate message to a particular database queue

edited Feb 10, 2014 10:59AM in GoldenGate, Streams and Distributed Database (MOSC) 2 commentsAnswered ✓

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,

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