Get Param Type
Retrieves the in/out type of the current stored-procedure
parameter.
Inputs
- CwDBStoredProcedureParam
- The stored-procedure parameter (a CwDBStoredProcedureParam object)
whose in/out type you want to retrieve.
Output
Returns the in/out type of the associated stored-procedure
parameter as an integer constant.
Notes
The Get Param Type function block returns the in/out parameter
type of the current stored-procedure parameter. The in/out parameter
type indicates how the stored procedure uses the parameter. The CwDBStoredProcedureParam class represents each in/out type as a constant, as Table 73 shows.
Table 73. Parameter in/out types (Get Param Type function block)
Parameter in/out type |
Description |
In/out type constant |
IN parameter |
An IN parameter is input only;
that is, the stored procedure accepts its value as input but does not use
the parameter to return a value. |
PARAM_IN |
OUT parameter |
An OUT parameter is output only;
that is, the stored procedure does not read
its value as input but does use the parameter to return a value. |
PARAM_OUT |
INOUT parameter |
An INOUT parameter is input and output; that
is, the stored procedure accepts its value as input and also uses
the parameter to return a value. |
PARAM_INOUT |
Related information
This function block is based on the CwDBStoredProcedureParam.getParamType() method.
For more information, see getParamType().
