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, settingBREAK_POLL_SKIP=1
in the server'ssqlnet.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 asSQL_PARAM_INPUT_OUTPUT
and having a PL/SQL procedure withIN OUT
parameter, and if the parameter is not changed in the procedure, then the driver does not returnSQL_NULL_DATA
inStrLen_or_IndPtr
. -
The Oracle Database ODBC driver does not support the usage of
Keyset
cursors with theCASE
clause in a SQLSELECT
query.
Parent topic: Appendix: Unsupported Features and Known Issues