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(TM) 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

Calling stored procedures with executeStoredProcedure()

executeStoredProcedure()

Copyright IBM Corp. 2004, 2005