|
|
|
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 types
// integer, string and numeric respectively.
SQLPStatement pstmt = new SQLPStatement("call cust_proc(?,?,?)");
pstmt.registerOutParam(2, CHAR);
pstmt.registerOutParam(3, NUMERIC);
pstmt.execute();
// Process results
END
