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
In the
Configuration tab of the adapter service, click the
Class Reference link.
In the opened AE schema, click the
Classes tab.
In the
All Classes panel, click
procedure_aeclass_name > user_specified_procedure_name > REQUEST.
The
Configuration panel of the selected object is displayed.
In the
Configuration panel, click the
Type link.
The
Classes tab of the selected procedure is displayed.
In the
All Classes panel, click
INPUT_OPTIONS > MAXROWS.
In the
Configuration panel, specify a value in the
Default Value field to set the maximum number of rows to be fetched.