Passing a TABLE or TABLE-HANDLE as an INPUT parameter

When the client application passes a static temp-table as an INPUT parameter, the client provides an object that contains data for the table. In this instance, the proxy already knows the schema (meta data) for the table; therefore, the client application does not need to supply the schema.

When the client application passes a TABLE–HANDLE parameter, the proxy does not know the schema (meta data) for the table. The client must provide both the schema and data for the TABLE–HANDLE parameters.

For an INPUT TABLE or TABLE-HANDLE parameter, you provide an instance of a class that implements the java.sql.ResultSet interface. You then pass this class instance directly as the INPUT TABLE or TABLE-HANDLE parameter.