Retrieves the in/out type of the current stored-procedure parameter.
- CwDBStoredProcedureParam
- The stored-procedure parameter (a CwDBStoredProcedureParam object) whose
in/out type you want to retrieve.
Returns the in/out type of the associated stored-procedure parameter as an
integer constant.
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 67 shows.
Table 67. 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
|
This function block is based on the
CwDBStoredProcedureParam.getParamType() method. For more
information, see getParamType().
