CwDBStoredProcedureParam()

Constructs a new instance of CwDBStoredProcedureParam that holds argument information for the parameter of a stored procedure.

Syntax

CwDBStoredProcedureParam(int paramType, String paramValue);

CwDBStoredProcedureParam(int paramType, int paramValue);
CwDBStoredProcedureParam(int paramType, Integer paramValue);
CwDBStoredProcedureParam(int paramType, Long paramValue);

CwDBStoredProcedureParam(int paramType, double paramValue);
CwDBStoredProcedureParam(int paramType, Double paramValue);
CwDBStoredProcedureParam(int paramType, float paramValue);
CwDBStoredProcedureParam(int paramType, Float paramValue);
CwDBStoredProcedureParam(int paramType, BigDecimal paramValue);

CwDBStoredProcedureParam(int paramType, boolean paramValue);
CwDBStoredProcedureParam(int paramType, Boolean paramValue);

CwDBStoredProcedureParam(int paramType, java.sql.Date paramValue);
CwDBStoredProcedureParam(int paramType, java.sql.Time paramValue);
CwDBStoredProcedureParam(int paramType, java.sql.Timestamp paramValue);

CwDBStoredProcedureParam(int paramType, java.sql.Blob paramValue);
CwDBStoredProcedureParam(int paramType, java.sql.Clob paramValue);

CwDBStoredProcedureParam(int paramType, byte[] paramValue);
CwDBStoredProcedureParam(int paramType, Array paramValue);
CwDBStoredProcedureParam(int paramType, Struct paramValue);

Parameters

paramType
The in/out parameter type of the associated stored-procedure parameter.
paramValue
The argument value to send to the stored procedure. This value is one of the following Java data types

Return values

Returns a new CwDBStoredProcedureParam object to hold the argument information for one argument in the declaration of the stored procedure.

Exceptions

None.

Notes

The CwDBStoredProcedureParam() constructor creates a CwDBStoredProcedureParam instance to describe one parameter for a stored procedure. Parameter information includes the following:

You provide a Java Vector of stored-procedure parameters to the executeStoredProcedure() method, which creates a stored-procedure call from a stored-procedure name and the parameter vector, and sends this call to the database associated with the current connection.

See also

executeStoredProcedure()

Copyright IBM Corp. 2004, 2005