Setting Maximum Rows in the Operation Level

For custom RPC Service, you can specify the maximum number of rows to be fetched in the operation level. At run time, the adapter fetches the number of rows according to the value set in the operation level instead of the service level.

Prerequisites

A stored procedure, function, or package is selected for custom RPC Service.

Procedure

  1. In the Configuration tab of the adapter service, click the Class Reference link.
  2. In the opened AE schema, click the Classes tab.
  3. In the All Classes panel, click procedure_aeclass_name > user_specified_procedure_name > REQUEST.
    The Configuration panel of the selected object is displayed.

  4. In the Configuration panel, click the Type link.
    The Classes tab of the selected procedure is displayed.

  5. In the All Classes panel, click INPUT_OPTIONS > MAXROWS.
  6. In the Configuration panel, specify a value in the Default Value field to set the maximum number of rows to be fetched.