||Oracle Tips by Burleson
Oracle 10g Rule-based Propagations for User-enqueued
In the example above, an apply rule is created
for the apply_site1_msg apply process. The rule instructs the apply
process to dequeue messages of the oe.cust_address_typ from the
streams_queue that contain a country code of US.
The set_message_notification procedure sets a
notification for messages dequeued by a specified streams messaging
client from a specific queue. With the help of this procedure, you
can do the following:
Specify an email address to which message
notifications are sent
Register a procedure to be invoked on a
Register a http url to which the
notification is posted
Let us look at an example showing its usage. To
send e-mail notification, use the following PL/SQL block:
streams_name => 'oe',
notification_action => 'email@example.com',
notification_type => 'MAIL',
include_notification => true,
queue_name => 'STRMADMIN.STREAMS_QUEUE');
The include_notification parameter turns
notification on or off for the specified queue. Here are the
notification_type and notification_action combination.
For PL/SQL procedure notifications, specify a
PL/SQL procedure name:
notification_type => 'PROCEDURE'
notification_action => 'oe.notify_address_arrival'
For email notifications, specify an email
notification_type => 'MAIL'
notification_action => 'firstname.lastname@example.org'
For URL notifications, specify a URL without
the prefix http://
notification_type => 'HTTP'
Get the complete story:
To get the code instantly, click here:
Need an Oracle Mentor?
BEI is now offering personal mentors for Oracle DBAs where you can have an
Oracle expert right at your fingertips, anytime day or night. We work with
hundreds of Oracle databases every year, so we know exactly how to quickly
assist you with any Oracle question.
Why risk an unplanned outage? You can now get telephone access to Don
Burleson or any of his Oracle Certified DBAs with more than 20 years of
full-time IT experience. Click here for details: