Edit

Operations on Functions and Procedures with RECORD Types in Oracle Database

  • Article

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?