1. Using the Microsoft SQL Server Adapter with Oracle Integration 3
  2. Add the Microsoft SQL Server Adapter Connection to an Integration
  3. Stored Procedure Page

Stored Procedure Page

Enter the stored procedure parameters.

Note:

  • Stored procedures return binary large objects (for example, BLOB database data types) as base64Binary types in XML. Depending upon the use cases, these can be decoded during transformation using inbuilt functions such as decodeBase64 or can be passed as-is for downstream processing.
  • Adapter input/output parameters are defined based on the stored procedure IN/OUT parameters. The IN parameter corresponds to the request and the OUT parameter is translated as the response.
Element Description

Select Schema

Select a database schema from the list that includes the data you want to query (for example, you want to query details about an employee based on their employee ID). This action refreshes the page to display fields for selecting a package or procedure to invoke.

Select Package

Select the database package. This action refreshes the page to display the procedures available for the package.

Select Procedure

Displays the in (inbound), out (outbound), and in/out (inbound/outbound) parameters for the selected package.

Arguments

Display the in, out, and in/out parameters that are passed with this procedure.