Try OpenEdge Now
skip to main content
Java Open Clients
Passing Temp-tables as SQL ResultSet Parameters : Passing a TABLE or TABLE-HANDLE as an INPUT-OUTPUT parameter
 

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.