Setting Up the WF_EVENT_OMB_QH Queue Handler (Oracle Workflow Administrator's Guide)

Oracle Workflow Administrator's Guide
Release 2.6.3
Part Number B10283-02


	Previous	Next		Contents	Index	Glossary

Step 17 Setting Up the WF_EVENT_OMB_QH Queue Handler

You need to perform this step only if you are using the Business Event System with Oracle8i

Database 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, Oracle Workflow Developer's Guide.

Note: You do not need to perform this step if you are using Oracle9i Database and higher. In these versions of the Oracle Database, 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.

Step 17 Setting Up the WF_EVENT_OMB_QH Queue Handler

To Set Up WF_EVENT_OMB_QH

See Also