Product Documentation

FairCom Java & .NET Stored Procedures

Previous Topic

Next Topic

SQLPStatement.registerOutParam

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

TOCIndex