||Oracle Tips by Burleson
Oracle 10g Rule-based Propagations for User-enqueued
A new procedure, add_message_propagation_rule in the dbms_streams_adm package
enables you to configure propagations and create rules for
propagations that propagate user-enqueued messages.
A new procedure, set_message_notification in the dbms_streams_adm package, enables you to configure message
notifications that are sent when a Streams messaging client dequeues
messages. The notification can be sent to an email address, a URL,
or a pl/sql procedure.
Let us see some examples to explain the
any_payld := SYS.AnyData.ConvertObject(
queue_name => 'STRMADMIN.STREAMS_QUEUE',
payload => any_payld);
We have enqueued the customer address in the
Now, use the dequeue method to dequeue and
display the details as shown in the example below. Here the
messaging client is ‘oe’.
queue_name => 'strmadmin.streams_queue',
streams_name => 'oe',
payload => any_payld,
navigation => 'NEXT MESSAGE');
num_var := any_payld.GETOBJECT(cust_addr);
address for the city of ' || cust_addr.city);
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: