Previous | Next | Contents | Index | Glossary |
Oracle Workflow provides a queue handler called WF_EVENT_OMB_QH which you can use to translate between the standard Workflow WF_EVENT_T message structure and the OMBAQ_TEXT_MSG structure. See: Setting Up the WF_EVENT_OMB_QH Queue Handler and Agents.
Among other attributes, the OMBAQ_TEXT_MSG datatype contains an attribute called TEXT_LOB, which contains the message payload in CLOB format, and another attribute called HEADER, whose datatype is another ADT called OMBAQ_HEADER.
OMBAQ_HEADER in turn contains an attribute called PROPERTIES, whose datatype is a third ADT, a named varying array called OMBAQ_PROPERTIES. The maximum size of OMBAQ_PROPERTIES is 1000, and the datatype of its elements is a fourth ADT, OMBAQ_PROPERTY.
The following table shows how the attributes of the WF_EVENT_T message structure are mapped to the attributes within the OMBAQ_TEXT_MSG structure.
WF_EVENT_T | OMBAQ_TEXT_MSG |
---|---|
WF_EVENT_T.PRIORITY | ombaq_properties(5).str_value [name = PRIORITY] |
WF_EVENT_T.SEND_DATE | ombaq_properties(6).str_value [name = SENDDATE] |
WF_EVENT_T.RECEIVE_DATE | ombaq_properties(7).str_value [name = RECEIVEDATE] |
WF_EVENT_T.CORRELATION_ID | ombaq_properties(8).str_value [name = CORRELATIONID] |
WF_EVENT_T.EVENT_NAME | ombaq_properties(9).str_value [name = EVENTNAME] |
WF_EVENT_T.EVENT_KEY | ombaq_properties(10).str_value [name = EVENTKEY] |
WF_EVENT_T.EVENT_DATA | text_lob (CLOB) |
WF_EVENT_T.FROM_AGENT.NAME | ombaq_properties(1).str_value [name = FROMAGENTNAME] |
WF_EVENT_T.FROM_AGENT.SYSTEM | ombaq_properties(2).str_value [name = FROMAGENTSYSTEM] |
WF_EVENT_T.TO_AGENT.NAME | ombaq_properties(3).str_value [name = TOAGENTNAME] |
WF_EVENT_T.TO_AGENT.SYSTEM | ombaq_properties(4).str_value [name = TOAGENTSYSTEM] |
WF_EVENT_T.ERROR_SUBSCRIPTION | ombaq_properties(11).str_value [name = ERRORSUBSCRIPTION] |
WF_EVENT_T.ERROR_MESSAGE | ombaq_properties(12).str_value [name = ERRORMESSAGE1] |
WF_EVENT_T.ERROR_MESSAGE | ombaq_properties(13).str_value [name = ERRORMESSAGE2] |
WF_EVENT_T.ERROR_STACK | ombaq_properties(14).str_value [name = ERRORSTACK1] |
WF_EVENT_T.ERROR_STACK | ombaq_properties(15).str_value [name = ERRORSTACK2] |
WF_EVENT_T.PARAMETER_LIST | ombaq_properties(16).str_value [name = PARAMETER00001] |
... | ... |
WF_EVENT_T.PARAMETER_LIST | ombaq_properties(115).str_value [name = PARAMETER00100] |
Previous | Next | Contents | Index | Glossary |