Pass a TABLE or TABLE-HANDLE as an INPUT parameter
- Last Updated: March 30, 2020
- 1 minute read
- OpenEdge
- Version 12.2
- Documentation
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.