I would think that it should be possible to have Oracle's Advanced Queues feature deliver a message to the appropriate MS Message Queue. I know Oracle AQ can be integrated with IBM MQSeries and JMS, so I believe it should work with Microsoft's queues. If it does, that would be a lot more efficient than a trigger and an external procedure.

Justin Cave
Distributed Database Consulting, Inc.
http://www.ddbcinc.com

-----Original Message-----
From: Allen Chan [mailto:allen.[Email Address Removed]
Sent: Thursday, February 26, 2004 10:01 AM
To: LazyDBA.com Discussion
Subject: Putting an event into MS Message queue


Hi, folks:
We have a complex MS Message Queue system in place where Layer 1 does real
time communication with units in the field, Layer 2 does all business
checking and prep of Insert/update, and Layer 3 does all the bulk insert to
our Oracle data base.
Layer1 has no database connectivity and it can only access Layer 2's queue.
Now there is a requirement on Layer 1 where a user changes something on the
database on any dial-in unit, Layer 1 has to know and determine the course
of action.
I'm thinking of using the Oracle EXTPROC function where a trigger will
invoke the C++ pgm and this C++ pgm will insert something onto the Layer 2
queue (On another W2K box). I know it will work but don't know if this is
the best solution, please comment on that.

--------
Get today's cartoon: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] using this list you agree to these terms:http://www.lazydba.com/legal.html



Oracle LazyDBA home page