Export (0) Print
Expand All

Operations on Functions and Stored Procedures

The Microsoft BizTalk Adapter for Oracle E-Business Suite supports Oracle functions and procedures 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.

    Dd788300.Important(en-us,BTS.70).gifImportant
    If you pass an invalid parameter in a function (that is, pass a string value for a numeric field), the Oracle E-Business adapter might throw an exception depending on the ODP.NET behavior. This is because the Oracle E-Business adapter uses ODP.NET to communicate with Oracle E-Business Suite.

  • 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.

    Dd788300.Important(en-us,BTS.70).gifImportant
    As part of a procedure, if you insert or update a decimal value (for example, 15.2) into a numeric field of an interface table or database table, the Oracle E-Business adapter will throw an exception. This is because the Oracle E-Business adapter uses ODP.NET to communicate with Oracle E-Business Suite, and ODP.NET does not support accepting decimal values for the numeric fields.

  • REF CURSOR types are supported for IN and 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

Dd788300.note(en-us,BTS.70).gifNote
You can also set the applications context for functions and stored procedures in Oracle E-Business adapter. For information about applications context, and how to set it, see Setting Application Context.

Show:
© 2014 Microsoft