An external or internal application wants to send inbound data to your Oracle database, like for example a purchase order or a receivable invoice. You want to consume this data in real time.
The version of your Oracle database is 11gR2 or above. The only “tool” you have is the Oracle database, i.e. you do not have any middleware (like SOA suite) installed. The external or internal application can connect to your Oracle database.
The following is a fully functional example of the solution, starting from creating a new database user and ending with consuming the message in the database.Comments Off on Event-based Scheduler Jobs and Oracle Streams Advanced Queuing: A Powerful Combination | Filed in Oracle | Tags: AQ, dbms_scheduler