Operations on functions and stored procedures in Oracle Database

The Microsoft BizTalk Adapter for Oracle Database supports Oracle functions, procedures, and packages in the following manner:

• Functions are surfaced as operations. The name of the operation is the name of the Oracle function. IN, OUT, and IN OUT parameters are supported, as well as, RETURN values.

• Procedures are surfaced as operations. The name of the operation is the name of the Oracle procedure. IN, OUT, and IN OUT parameters are supported.

• Packaged functions and procedures are surfaced as operations. The name and namespace of the operation (function or procedure) is qualified by the name of the Oracle package. Overloads are supported in packages (see next bullet).

• Overloaded functions and procedures in packages are surfaced as operations. Each overloaded function or procedure is surfaced with a string appended to its name that identifies the overload. This string is part of the sequence "overload1", "overload2", "overload3", and so on.

• REF CURSOR types are supported for IN, OUT, and IN OUT parameters for procedures and functions, as well as for function RETURN values. For more information, see Operations on Functions and Procedures with REF CURSOR Parameters.

• RECORD types are supported for IN, OUT, and IN OUT parameters for procedures and functions, as well as for function RETURN values. Both simple and complex (nested) RECORD types are supported. Operations on Functions and Procedures with RECORD Types

  For more information about:

• Invoking an Oracle procedure or function by using BizTalk Server, see Invoke Functions and Procedures in Oracle Database using BizTalk Server and Invoke Overload Functions and Procedures in Oracle Database using BizTalk Server.

• Invoking an Oracle procedure or function by using the WCF service model, see Invoke Functions and Procedures in Oracle Database using the WCF Service model.

• Invoking an Oracle procedure or function by using the WCF channel model, see Invoke a Function in Oracle Database using the WCF Channel Model.

• Message structure and SOAP actions used to invoke Oracle procedures and functions, see Message Schemas for Functions and Procedures.

See Also

What Operations Can be Performed Using the Adapter?