Contents	Index	Glossary	Master Index	Feedback

and you want to use Oracle Message Broker (OMB) to propagate event messages between systems. The WF_EVENT_OMB_QH queue handler translates between the standard Workflow event message structure, WF_EVENT_T, and the structure required by OMB queues, OMBAQ_TEXT_MSG.

After you set up WF_EVENT_OMB_QH, you can assign this queue handler to Business Event System agents that use propagation protocols you have implemented through OMB. See: Agents.

Note: You do not need to perform this step if you are using Oracle9i. In Oracle9i, you can use the Messaging Gateway and Internet access features of Oracle Advanced Queuing to propagate event messages, in place of Oracle Message Broker.

Context: You need to perform this step only once.

   To Set Up WF_EVENT_OMB_QH

• 1. Use OMB to create the AQ queues that you want to use for event message propagation. The queues should be single-consumer queues created in your Oracle Workflow schema. You should create at least one inbound and one outbound queue. For example, create queues called WF_OMB_IN and WF_OMB_OUT.

• 2. Run the script wfquhndos.pls to create the PL/SQL spec for the WF_EVENT_OMB_QH package. This script is located in the wf/sql subdirectory in your Oracle Home.

• 3. Run the script wfquhndob.pls to create the PL/SQL body for the WF_EVENT_OMB_QH package. This script is located in the wf/sql subdirectory in your Oracle Home.

See Also

Event Message Structure

Mapping Between WF_EVENT_T and OMBAQ_TEXT_MSG

Copyright © 1996, 2002 Oracle Corporation.
All Rights Reserved.