msgbartop
News, views, tips and tricks on Oracle and other fun stuff
msgbarbottom

Event-based Scheduler Jobs and Oracle Streams Advanced Queuing: A Powerful Combination

Problem:

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.

Assumptions:

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.

Solution:

Use Oracle Streams Advanced Queuing (AQ) for messaging. Use an event-based scheduler job for real time data consumption. Both are standard features of the Oracle database.

Implementation Steps:

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.

Continue reading…

Comments Off | Filed in Oracle | Tags: ,