Configuring MySQL Adapter Stored Procedure Properties

Enter the MySQL Adapter stored procedure parameters.

What You Can Do from the Invoke a Stored Procedure Page

You can specify the following values on the Invoke a Stored Procedure page. The Invoke a Stored Procedure page is the wizard page that is displayed if you selected Invoke a Stored Procedure as the operation type on the Basic Info page.

  • Select the database schema that includes the data you want to query (for example, you want to query details about an employee based on their employee ID).
  • Select a stored procedure or package from the list that is displayed after you select the database schema.

What You See on the Invoke a Stored Procedure Page

The following table describes the key information on the Invoke a Stored Procedure page.

Element Description

Select Schema

Select a database schema from the list. This action refreshes the page to display fields for selecting a package or procedure to invoke.

Select Package

Select the database package.

Select Procedure

Select the stored procedure. The page is refreshed to display the in (inbound), out (outbound), and in/out (inbound/outbound) parameters available with this procedure.

Arguments

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