A.1.3 Known Software Issues

The following are the known software issues and unsupported usage in the Oracle Database ODBC driver:

  • The SQLSetStmtOption SQL_QUERY_TIMEOUT does not work if the database server is running on Windows NT. As a workaround, setting BREAK_POLL_SKIP=1 in the server's sqlnet.ora file solves the problem. By default, this is set to 100, and the database would not check for a time-out set by the ODBC application.

  • SQLBindParameter, when used to bind a buffer as SQL_PARAM_INPUT_OUTPUT and having a PL/SQL procedure with IN OUT parameter, and if the parameter is not changed in the procedure, then the driver does not return SQL_NULL_DATA in StrLen_or_IndPtr.

  • The Oracle Database ODBC driver does not support the usage of Keyset cursors with the CASE clause in a SQL SELECT query.