Passing a TABLE or TABLE-HANDLE as an INPUT-OUTPUT parameter

INPUT–OUTPUT TABLE and TABLE-HANDLE parameters are a combination of INPUT and OUTPUT parameters.

For an INPUT-OUTPUT parameter, you must pass an instance of com.progress.open4gl.ResultSetHolder, which contains a reference to a client-supplied java.sql.ResultSet object instance. On output, the holder object contents are changed to reference a com.progress.open4gl.ProResultSet object instance.

If the parameter is a TABLE-HANDLE, the value returned can be unknown. As a result, calling getResultSetValue() on the holder returns null.

For more information on creating a java.sql.ResultSet for input, see Passing a TABLE or TABLE-HANDLE as an INPUT parameter. For more information on ProResultSet objects, see Accessing TABLE or TABLE-HANDLE parameters as OUTPUT.