Operations on Functions and Procedures with RECORD Types
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 Microsoft BizTalk Adapter for Oracle E-Business Suite 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 E-Business adapter does not support BFILE types as RECORD members.
Other ResourcesWhat Operations Can Be Performed Using the Adapter?
© 2014 Microsoft Corporation. All rights reserved.