Operations on Functions and Stored Procedures
The Microsoft BizTalk Adapter for Oracle E-Business Suite supports Oracle functions and procedures.
Functions and 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.
Important
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.
Important
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
Note
You can also set the application context for functions and stored procedures in Oracle E-Business adapter. For information about application context, and how to set it, see Set Application Context.