Data Requester: OracleDataRequester_CustomRPC Project

The OracleDataRequester_CustomRPC project contains four processes demonstrating remote procedure call mode using stored procedures and functions.

The processes in this project are:
  • Execute_procedure_FINDORDERS
  • Execute_procedure_GETPRICE
  • Execute_procedure_PARAMTEST
  • Execute_procedure_SETDESCRIPTION

JDBC Connection Resource

In this example, the JDBC Connection resource is configured as follows:

ADB Connection Resource

In this example, the ADB Configuration resource is configured as follows:

The structure of the selected stored procedure is displayed on the Schema tab. The Configuration tab is used to specify the mode and to select custom operations. In the following figure, RPC mode with custom operations has been selected.

Execute_procedure_FINDORDERS Process

The following figure shows the General tab of the Execute_procedure_FINDORDERS process:

Execute_procedure_GETPRICE Process

The following figure shows the General tab of the Execute_procedure_GETPRICE process:

Execute_procedure_PARAMTEST Process

The following figure shows the General tab of the Execute_procedure_PARAMTEST process:

Execute_procedure_SETDESCRIPTION Process

The following figure shows the General tab of the Execute_procedure_SETDESCRIPTION process: