Message Schemas for RECORD Types
Oracle RECORD types are structured PL/SQL data types that consist of one or more simple or structured database types. RECORD types are primarily used in PL/SQL stored procedures and functions to send and receive hierarchical data.
The Microsoft BizTalk Adapter for Oracle Database supports RECORD types in the following manner:
RECORD types are surfaced as complex types.
RECORD types can be nested (record in a record).
RECORD types can be declared as TABLE%ROWTYPE parameters in stored procedures and functions.
RECORD types can be declared as TYPE of RECORD parameters in PL/SQL packages; for example,
TYPE rec_type1 IS RECORD(name varchar2(100), age number(3));
.Note
The Oracle Database adapter does not support BFILE types as RECORD members.
When a RECORD type parameter is used in a stored procedure or a function, it is qualified with the namespace of that operation. The following XML shows the structure of a RECORD type in a message:
<[REC_PARAM_NAME]>
<[FIELD_NAME1] xmlns="[OPERATION_NAMESPACE]">value1</[FIELD_NAME1]>
<[FIELD_NAME2] xmlns="[OPERATION_NAMESPACE]">value2</[FIELD_NAME2]>
…
</[REC_PARAM_NAME]>
[REC_PARAM_NAME] is the name of the RECORD parameter.
[FIELD_NAME] is the name of a field in the RECORD type.
[OPERATION_NAMESPACE] is the namespace of the stored procedure or function in which the RECORD parameter is being used.
The following XML shows the structure of a RECORD type parameter with a nested RECORD type field:
<[REC_PARAM_NAME]>
<[FIELD_NAME1] xmlns="[OPERATION_NAMESPACE]">value1</[FIELD_NAME1]>
<[FIELD_NAME2] xmlns="[OPERATION_NAMESPACE]">value2</[FIELD_NAME2]>
<[REC_PARAM_NAME2]>
<[FIELD_NAME1] xmlns="[OPERATION_NAMESPACE]">value1</[FIELD_NAME1]>
<[FIELD_NAME2] xmlns="[OPERATION_NAMESPACE]">value1</[FIELD_NAME2]>
…
</[REC_PARAM_NAME2]>
…
</[REC_PARAM_NAME]>
See Also
Messages and Message Schemas for BizTalk Adapter for Oracle Database