Operations on Functions and Procedures with RECORD Types in Oracle Database

Oracle RECORD types are used to represent hierarchical information in parameters passed to PL/SQL functions and procedures. The Microsoft BizTalk Adapter for Oracle Database surfaces RECORD types as complex XML types. The Oracle Database adapter supports the following kinds of RECORD types:

• RECORD types that are declared as TABLE%ROWTYPE parameters in stored procedures and functions.

• RECORD types that are declared as TYPE of RECORD parameters in PL/SQL packages for example, TYPE rec_type1 IS RECORD(name varchar2(100), age number(3));

• RECORD types that contain nested records.

• RECORD types that appear as IN, OUT, or IN OUT parameters to procedures or functions.

• RECORD types that are RETURN values of functions.

  Note

  The Oracle Database adapter does not support BFILE types as RECORD members.

  For information about:

• Invoking a function or procedure involving RECORD types using the WCF service model, see Run Operations Using RECORD Types in Oracle Database using the WCF Service Model.

• Invoking a function or procedure involving RECORD types using BizTalk Server, see Invoke Functions and Procedures with RECORD Types by Using BizTalk Server.

• XML structure for RECORD types as supported by the Oracle Database adapter, see Message Schemas for RECORD Types.

See Also

What Operations Can be Performed Using the Adapter?