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

"Calling stored procedures with executeStoredProcedure()"

executeStoredProcedure()

Copyright IBM Corp. 1997, 2004