BBjStoredProcedureData::setResultSet

Description

In BBj 6.0 and higher, this method sets the channel to be used as the stored procedure's result set.

Syntax

Return Value	Method
void	setResultSet(java.sql.ResultSet p_sqlChannel)

Parameters

Variable	Description
p_resultSet	Instance of java.sql.ResultSet to return.

Return Values

None.

Remarks

Either this method or setUpdateCount can be called once. Subsequent invocations result in an !ERROR=207 (BBJ_STATE).

Example

rem 'A sample Stored Procedure program

rem 'Get a Stored Procedure object from the BBj File System
sp! = BBjAPI().getFileSystem().getStoredProcedureData()

rem 'Get the input parameter from the application
NAME$ = sp!.getParameter("NAME")

rem 'Open up the database that the client application is using
con! = BBjAPI().getJDBCConnection(sp!.getDatabaseName())

rem 'Now generate and return the result set back to the client application
stmt! = con!.prepareStatement("select * from customer where first_name like ?")
stmt!.setString(1, NAME$)
rs! = stmt!.executeQuery()
sp!.setResultSet(rs!)