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.
Oracle LazyDBA home page