public interface ResultSetHandleAn implementation of this interface is returned from functions and procedures that are declared to return
SET OFa complex type in the form of a
ResultSet. The primary motivation for this interface is that an implementation that returns a ResultSet must be able to close the connection and statement when no more rows are requested.
A function returning a
SET OFa complex type generated on the fly (rather than obtained from a query) would return
ResultSetProviderinstead. One returning a
SET OFa simple type should simply return an
In the case of a function declared to return
SETOF RECORDrather than of a complex type known in advance, SQL requires any query using the function to include a column definition list. If the number of those columns does not match the number in the
ResultSetreturned here, only as many as the caller expects (in index order starting with 1) will be used; an exception is thrown if this result set has too few columns. If the types expected by the caller differ, values are converted as if retrieved one by one from this
ResultSetand stored into the caller's with
A function that needs to know the names or types of the caller's expected columns should implement
- Thomas Hallgren
ResultSet getResultSet() throws SQLExceptionAn implementation of this method will probably execute a query and return the result of that query.
- The ResultSet that represents the rows to be returned.