Oracle ODBC Driver Truncates The Data Length of Output Parameter When Data Type is SQL_VARCHAR/SQL_WVARCHAR

(Doc ID 2101352.1)

Last updated on JUNE 29, 2017

Applies to:

Oracle ODBC Driver - Version and later
Microsoft Windows x64 (64-bit)
Microsoft Windows (32-bit)
**Checked for relevance on 29-Jun-2017**


The data length of output parameter is truncated while using Oracle ODBC driver when it is of type SQL_VARCHAR or SQL_WVARCHAR.
The issue is identified in Oracle Client

The data length was 36 in earlier versions ( and lower versions). With Oracle Client it became 18.



 Upgraded Oracle ODBC driver (Oracle Client) from (or lower version) to


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms