ODBC Programmer Reference › Procedures › Using Procedures › Bind Parameters

Bind Parameters

The application uses the SQLBindParameter or SQLSetDescriptor functions to specify the type and buffer for each parameter. Even though all parameters are actually SQL_PARAM_INPUT_OUTPUT, the driver allows an application to bind the parameters as SQL_PARAM_INPUT or SQL_PARAM_OUTPUT. If a parameter is bound as SQL_PARAM_INPUT or SQL_PARAM_INPUT_OUTPUT, the buffer must contain the input value or NULL when the statement is executed. If a parameter is bound as SQL_PARAM_OUTPUT the driver assumes a NULL value.