|
|
|
This method registers the expected type of OUT and INOUT parameters. This method is common for SQLCursor, SQLIStatement and SQLPStatement classes.
Format
public void registerOutParam(int pIndex, short dType)
Returns
None
Parameters
pIndex
An integer that specifies which OUT/INOUT parameter is to be registered (1 denotes the first parameter, 2 denotes the second, and so on).
dType
The expected type of the OUT/INOUT parameter.
Throws
DhSQLException
Example
CREATE PROCEDURE register_proc()
BEGIN
// cust_proc is a procedure with an IN, OUT and an INOUT arguments of type
// integer, string and numeric respectively.
SQLIStatement istmt = new SQLIStatement("call cust_proc(?,?,?)");
istmt.registerOutParam(2, CHAR);
istmt.registerOutParam(3, NUMERIC);
istmt.execute();
// Process results
END
