Previous	Next		Contents	Index	Glossary

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.

See Also

Event Message Structure, Oracle Workflow API Reference

Mapping Between WF_EVENT_T and OMBAQ_TEXT_MSG, Oracle Workflow API Reference

Copyright © 2003 Oracle Corporation.
All rights reserved.