Data format

The Oracle AQ Adapter formats message data as infix delimited, using a vertical bar (|) as the delimiter. Groups (ADT types) are denoted with a left bracket as the initiator ([) and a right bracket as the terminator (]) to facilitate detection of null groups. (A null group indicates that the entire ADT is null, not just individual members within the group.)

Only the nested ADTs are initiated or terminated; the top ADT group is not.

Because a vertical bar (|), left bracket ([), and right bracket (]) are special characters, when these characters are present in any message, they are released with an exclamation point (!) release character. This process should be transparent to the user.

Note: If an ADT type queue is used, one consisting of only simple types (no nested ADTs), the data itself must not contain any left bracket ([) or right bracket (]) special characters (the adapter releases them, but the type tree will not recognize them).

Using the Database Interface Designer with the Oracle adapters, you can create a type tree to reflect the message types and data format expected by the Oracle AQ Adapter.