Export (0) Print
Expand All

Operations on Functions and Stored Procedures

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:

Show:
© 2014 Microsoft