You must place all parameters for a procedure (external, persistent, and internal) or user-defined function into a com.progress.open4gl.javaproxy.ParamArray object before running the procedure or user-defined function.

You can create a ParamArray using the following constructor:

Syntax

public ParamArray(int numParams)
numParams
Specifies the total number of parameters (including all INPUT, INPUT-OUTPUT, and OUTPUT parameters).

You can add each parameter to the ParamArray using a set of methods that add a parameter based on the data type of the parameter or a single generic add parameter method. You must identify the parameter position as well as the mode of the parameter. For temp-tables and ProDataSets, you must identify the meta data. You must also pass in an initial value for input and input-output parameters.

If you want to reuse the ParamArray for another call:

  • The number of parameters for the next call must match the number of parameters in the ParamArray object
  • You must clear any current values in the ParamArray using the clear() method as follows: 
    // Create the ParamArray
ParamArray parms = new ParamArray(1);
...// Clear for reuse
parms.clear();