FIX: SQLPutData Truncates LONG RAW Data Using Oracle ODBC Driver

SYMPTOMS

Using the Microsoft ODBC Driver for Oracle (build 2.73.728303) that ships with MDAC 1.5c causes a SQL_SUCCESS_WITH_INFO message and a "Data Truncated" error when trying to store LONG RAW data with SQLPutData and using SQLBindParameter with the ColumnSize (6th Parameter) set to 0 or less than the actual length of the data. This occurs even though SQLGetInfo for SQL_NEED_LONG_DATA_LEN returns a "No". Also, no data is written to the LONG RAW field.

The problem occurs if you bind the parameter as a SQL_C_BINARY and SQL_BINARY like this:

g_rc = SQLBindParameter(g_hstmt, 1, SQL_PARAM_INPUT, SQL_C_BINARY,
SQL_BINARY, 0, 0, NULL, 0, &cbVal1);