Configure Oracle ODBC driver on UNIX platforms.
Platform
32-bit/64-bit
UnixODBC DM version
Most of the software bug fixes are generic in nature though some may have been discovered on a particular platform. There could be a small number of platform specific software bug fixes as well. Software bug fixes are described for the following versions:
Version 19.1.0.0.0
Version 18.1.0.0.0
Version 12.2.0.1.0
Version 12.1.0.2.0
Version 12.1.0.1.0
Version 11.2.0.2.0
Version 11.2.0.1.0
Version 11.1.0.1.0
Row insert operation in Oracle ODBC is no longer slower than the DataDirect ODBC Driver (Bug 23288642)
After migrating an 11gR2 ADO/ODBC application, it no longer causes the wrong result on a recordset operation. (Bug 19000463)
ODBC Driver API SQLStatistics
now passes the SCHEMANAME
value for filtering. (Bug 23259086)
ODBC SQLFetch
no longer fails with abort (core dumped) error. (Bug 23186348)
ODBC SQLFetch
no longer returns no data when binding a TIMESTAMP
column with SQL_C_CHAR
. (Bug 23120325)
Oracle ODBC driver returned an empty message string in the generated exception. (Bug 20517697)
Oracle ODBC driver crashed during a call of Oracle functions with return type REFCURSOR
. (Bug 20387007)
Oracle ODBC driver corrupted data when inserting an image of BLOB
type. (Bug 19720146)
Oracle ODBC driver SQLColumns()
API returned the wrong metadata for the TSLTZ
column. (Bug 19573657)
Oracle ODBC driver had different TSLTZ
outputs when binding with CHAR
types. (Bug 19545406)
Oracle ODBC driver quit at SQLFETCH()
with cursor type SQL_CURSOR_KEYSET_DRIVEN
. (Bug 19531841)
Oracle ODBC driver quit while fetching from a procedure that returns a REF
cursor. (Bug 19530596)
Oracle ODBC driver during a SQLFETCH()
gave an undefined symbol: M_FMEMALLOC
with SQL_C_WCHAR
. (Bug 19529966)
Oracle ODBC driver during a SQLFETCH()
quit when bound with SQL_C_CHAR
or SQL_C_BINARY
. (Bug 19529718)
Oracle ODBC driver crashed when passing more than 4093 characters. (Bug 19524047)
Oracle ODBC driver using a stored procedure with NCHAR
data type did not execute correctly with ODBC 12.1.0.1. (Bug 19158940)
Oracle ODBC driver 12.1.0.1 using a procedure returned NULL
. (Bug 19026257)
Migrating an Oracle Database 11g Release 2 (11.2) ADO/ODBC application caused the wrong result on a recordset operation. (Bug 19000463)
Oracle ODBC driver could not retrieve a CLOB
containing CHR(0)
. (Bug 18749178)
Oracle ODBC driver raised a database exception with an INSERT
statement with 11.2.0.3 + P30. (Bug 18681683)
Oracle ODBC driver got an access violation in Japanese environment when inserting over 64K data into a LONG RAW
column. (Bug 18606539)
Oracle ODBC driver reported an ORA-01461
error while inserting into NVARCHAR2
columns with the Chinese language. (Bug 18232462)
ODBC 12.1 application using a query with comments embedded in them failed with an ORA-24374
error. (Bug 18024745)
Oracle ODBC driver did not free a temporary LOB after fetching data from it. (Bug 17928169)
A Microsoft Access client hung trying to link a table over a database link. (Bug 17925209)
ODBC connection hung in Japanese environment when the CLOB
type contained the data of CHR(0)
. (Bug 17901129)
Oracle ODBC driver crashed on ORANLS12
. (Bug 17896495)
Oracle ODBC driver reported an ORA-1410
error when fetching data from an index organized table using KEYSET_DRIVEN
cursor. (Bug 17583959)
Oracle ODBC driver using a query returned a truncated value. (Bug 16959397)
ODBC application with a SQLFETCH
after SQLCOLUMNS
resulted in a SUCCESS_WITH_INFO
message for an invalid view. (Bug 16324625)
ODBC application with an array insert of LOBs resulted in the last LOB only being inserted multiple times. (Bug 16235055)
Oracle ODBC driver with an ODBC idle connection to Microsoft Access resulted in an ODBC call failed error. (Bug 16181438)
Oracle ODBC driver gave an access violation at SQLEXECUTE
when setting incorrect binding at TIMESTAMP
. (Bug 16009315)
Oracle ODBC driver after upgrade to 11.2, SQLSETPARAM
and SQL_WCHAR
(NCHAR
) resulted in corruption. (Bug 14623077)
Oracle ODBC driver reported an ORA-1843
or ORA–1830
error when inserting a DATE
type data the second time. (Bug 14308740)
Oracle ODBC driver reported an ORA-22275
error after an error ORA-1
, ORA-14400
error during insertion. (Bug 13518550)
ODBC application rarely returned an S1004
for a SQLFETCH
call in a multithreaded application. (Bug 13044472)
Oracle ODBC driver reported an error ORA-00918
for a query with inner join and KEYSET_DRIVEN
cursor. (Bug 9642938)
Oracle ODBC driver now supports TIMESTAMP WITH LOCAL TIME ZONE
data type. (Bug 7533808)
Oracle ODBC driver quit when using SQLPREPARE
with an invalid SQL statement. (Bug 7325015)
Array insert of type LOB resulted in inserting the last element into all the rows. (Bug 16491814)
ODBC application use to throw ORA-00918: column ambiguously defined
error when join and multiple tables were used in a query with a KEYSET_DRIVEN
cursor. (Bug 9642938)
Oracle ODBC driver use to result in ODBC call failed error when the ODBC driver tried to reconnect to Oracle Database after Microsoft Access connection timed out. (Bug 16181438)
Oracle ODBC driver use to give access violation at SQLExecute
when setting an incorrect bind parameter value for TIMESTAMP
database column. (Bug 16009315)
Oracle ODBC driver use to return string truncation error S1004
when a multithreaded application having common ENV handle across all threads uses SQL_C_TCHAR
C data type as the buffer type in SQLBindCol
when NLS_LANG
is JA16SJISTILDE
. (Bug 13044472)
Data truncation with MSADSQL and ATL library where applications rely on precision and scale field in SQL_NUMERIC_STRUCT
. (Bug 16959397)
Crash is due to array bind when the array bind is done a number of times. (Bug 17896495)
Temporary lob not free after data is fetched. (Bug 17928169)
When fetching data from index organized table using KEYSET-DRIVEN
cursor, it results in ORA-01410
error. (Bug 17583959)
ODBC data Source Administrator never use to show the fully qualified service name in the drop down box. (Bug 10236704)
Oracle ODBC driver use to fail when the CREATE PROCEDURE
statement has the wide character \r
. (Bug 14458246)
Oracle ODBC driver use to throw pop up window of change-password repeatedly when database password expired. (Bug 10353128)
ODBC driver use to hang and/or crash under a multithreaded environment and when there was a memory leak during multiple connects and disconnects. (Bug 9850419)
SQLGetData()
API of Oracle ODBC driver use to consume more time during scalability of threads versus processes. The threaded version of the application use to take more time than the process version. (Bug 9835629)
Oracle ODBC driver use to fail with access violation in SQLFetchScroll()
API with the SQL_FETCH_NEXT
option. (Bug 9578533)
Oracle ODBC driver use to return wrong columns_size
and buffer_length
values through SQLColumns()
APIs for CHAR
columns. (Bug 9414079)
Oracle ODBC driver use to return SQL_NO_DATA_FOUND
when SQL_ROWSET_SIZE
was set to more than the remaining rows. (Bug 9264668)
Oracle ODBC driver use to hang when transferring Microsoft Access table data to Oracle table. (Bug 8984021)
Oracle ODBC driver use to truncate returned data when there were more characters with multibyte in a selected row, with NLS_LENGTH_SEMANTICS=CHAR
and AL32UTF8
database character set. (Bug 8771556)
ODBC driver use to return wrong suffix and prefix lengths on 64-bit environment. (Bug 8429289)
ODBC driver use to fail during SQLConnect
on AIX environment when DM version is set to SQL_OV_ODBC2
. (Bug 8639577)
ODBC application use to fail on UNIX 64-bit environment when SQLFetchScroll()
with bind type SQL_C_SLONG
. (Bug 8735155)
ODBC driver use to truncate the data when there is multi-byte data in a selected row with combination of NLS_LENGTH_SEMANTICS=CHAR
and AL32UTF8
character set. (Bug 8771556)
ODBC driver use to crash on Solaris sparc64 while executing the statement. (Bug 8775499)
ODBC driver use to crash on HPUXIA64 while fetching FLOAT
/DOUBLE
data. (Bug 8974909)
ODBC Driver use to hang during transfer of Microsoft Access table data to Oracle table. (Bug 8984021)
ODBC driver use to fail on Windows 64-bit while adding data source using SQLConfigDataSource()
API. (Bug 9023338)
ODBC driver use to crash on Solaris while dealing with FLOAT
/DOUBLE
. Bug 9058381)
ODBC driver used return incorrect data on big endian environment when application binds date field to SQL_C_WCHAR
. (Bug 9070694)
ODBC driver use to crash on UNIX 64-bit environment when SQLGetConnectAttr()
is used with pointer to UNSIGNED INT
. (Bug 9105601)
ODBC driver use to map incorrect size for SQL_C_ULONG
, SQL_C_SLONG
, and SQL_C_LONG
types on UNIX 64-bit environment. (Bug 9463231)
Unicode ODBC application use to fail while SQL execution. (Bug 9743383)
ODBC Driver Configuration of "ODBC Data Source Administrator" use to show garbage values in the drop down list for TNS Service Name
when TNS_ADMIN
value is set in registry and not as environment variable. (Bug 8796983)
ODBC Driver use to return no-data-found in case of SQLROWSET_SIZE
is more than remaining rows application returns no-data-found when SQLROWSET_SIZE
is set more than the remaining rows after first fetch. (Bug 9264668)
Memory leak was reported in the ODBC driver while returning a result set from a stored procedure. (Bug 7586197)
ODBC was failing to update the LONG RAW
when the size was more than 65536 bytes. (Bug 7585970)
ODBC application use to fail with a NULL
password error when MTS was enabled. (Bug 7509964)
ODBC Driver use to return an access violation on executing a stored procedure. (Bug 7458976)
ODBC application use to hang when more connections were created. (Bug 7388606)
ODBC application use to crash when SQLSetParm()
was called with a string that is non NULL
terminated. (Bug 7011807)
ODBC Driver use to report an ORA-24817
error on querying a bulk operation. (Bug 6908070)
ODBC Driver use to return the wrong length and data fora SQLGetData()
call when using NLS character in literal and with NLS settings as NLS_LENGTH_SEMANTICS= CHAR
, NLS_CHARACTERSET = AL32UTF8
. (Bug 6801797)
ODBC driver use to crash on 64-bit environments while fetching data. (Bug 6801211)
ODBC Driver use to show the wrong types when using calls SQLDescribeParam()
, SQLDescribeCol()
, SQLColumns()
, SQLGetTypeInfo()
. (Bug 6598695)
ODBC driver use to crash with SQLGetStmtAttr()
call. (Bug 6416638)
ODBC driver use to report SIGBUS on Solaris SPARC as memory for cache blocks was not aligned. (Bug 6411945)
ODBC Driver use to return an [ORACLE][ODBC]Memory Allocation Error
, while describing metadata for a procedure. (Bug 6085754)
ODBC Driver use to report an error on executing a procedure after execution of the INSERT
statement. (Bug 5961436)
ODBC Driver use to report an ORA-24374
error whenever a SQL Statement was preceded by any valid tokens that did not give the SQL Statement type. (Bug 5383456)
ODBC Driver use to return the same error message twice with a SQLExecute()
call. (Bug 5222165)
ODBC Driver use to return an ORA-24374
error when executing a query that included a line comment. (Bug 4743995)
ODBC driver use to return old data on requering the data for a read-only connection. (Bug 5202103)
ODBC driver use to report an ORA-1008
error, when an MFC application requeries the database. (Bug 5147229)
ODBC driver use to return the wrong value on fetching a NUMBER
value that is converted to SQL_C_CHAR
. (Bug 5128512)
ODBC driver use to return the wrong information for few column types. (Bug 5015342)
ODBC driver use to report an ORA-12704
error on the second invocation of a SQLExecute()
call for NCLOB
columns. (Bug 4965677)
ODBC Driver use to report a crash on exit from an ADO and Excel applications. (Bug 4893583)
ODBC Driver use to return 0
as the data type on calling SQLBindCol()
after SQLColumns()
. This problem appears only on the Solaris platform, but the software fix is generic. (Bug 4880062)
ODBC Administrator use to show ODBC entries even after uninstalling the ODBC. (Bug 4761792)
ODBC driver use to truncate the data retrieved with the SQLFetchScroll()
call. (Bug 4735799)
ODBC driver use to result in an application crash while executing a stored procedure having a large number of parameters. (Bug 4727495)
DM from UNIXODBC.ORG
reports error: Driver does not support SQLSETSTMTATTR()
. This is a port specific (Linux and Solaris) bug. (Bug 4710548)
ODBC driver use to report an undefined symbol SLEEP
when fail over happened. (Bug 4698310)
ODBC Driver use to report a crash on inserting NULL
data using bind offsets. (Bug 4694220)
ODBC Driver use to set the value corresponding to attribute SQL_ATTR_PARAMS_PROCESSED_PTR
improperly when the stored procedure execution was with array binds. (Bug 4690201)
ODBC Driver use to report a crash when returning an array of VARCHAR
s from a stored procedure. (Bug 4690147)
ODBC Driver use to give an incomplete result set when the stored procedure contained REF CURSOR
arguments. (Bug 4624776)
ODBC driver use to report an error on executing a stored procedure containing REF CURSOR
parameters. (Bug 4622561)
ODBC Driver use to take more time fetching data from a NUMBER
column containing FLOAT
data. (Bug 4608183)
ODBC driver use to return duplicate results for a SQLProcedures()
call. (Bug 4565416)
ODBC Driver use to report a memory leak for a stored procedure containing REF CURSORS
. (Bug 4551675)
ODBC Driver use to return an ORA-1406
error when selecting a calculated number with a large precision from a view. (Bug 4546618)
ODBC driver use to report a crash for executing queries in a multithreaded application. (Bug 4519067)
ODBC administrator use to invoke English ODBC help in the Japanese environment. (Bug 4506552)
ODBC driver use to report the error Input string too long, limit 4096
, when the long string contained CRLF
code (\n
\r
) and contained more that 4096 characters after the CRLF characters. (Bug 4371966)
ODBC administrator use to fail while opening the help file under an Instant Client environment. (Bug 4309867)
ODBC Driver use to return the wrong data for stored procedures having NCLOB
as the OUT
Param
. (Bug 4235212)
ODBC catalogue functions use to take more time to complete. (Bug 4150034)
For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.
Access to Oracle Support
Oracle customers that have purchased support have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.
This software and related documentation are provided under a license
agreement containing restrictions on use and disclosure and are protected by
intellectual property laws. Except as expressly permitted in your license agreement or
allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license,
transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by
any means. Reverse engineering, disassembly, or decompilation of this software, unless
required by law for interoperability, is prohibited.
The information contained herein is subject to change without notice
and is not warranted to be error-free. If you find any errors, please report them to us
in writing.
If this is software or related documentation that is delivered to the
U.S. Government or anyone licensing it on behalf of the U.S. Government, then the
following notice is applicable:
U.S. GOVERNMENT END USERS: Oracle programs, including any operating
system, integrated software, any programs installed on the hardware, and/or
documentation, delivered to U.S. Government end users are "commercial computer software"
pursuant to the applicable Federal Acquisition Regulation and agency-specific
supplemental regulations. As such, use, duplication, disclosure, modification, and
adaptation of the programs, including any operating system, integrated software, any
programs installed on the hardware, and/or documentation, shall be subject to license
terms and license restrictions applicable to the programs. No other rights are granted
to the U.S. Government.
This software or hardware is developed for general use in a variety of
information management applications. It is not developed or intended for use in any
inherently dangerous applications, including applications that may create a risk of
personal injury. If you use this software or hardware in dangerous applications, then
you shall be responsible to take all appropriate fail-safe, backup, redundancy, and
other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim
any liability for any damages caused by use of this software or hardware in dangerous
applications.
Oracle and Java are registered trademarks of Oracle and/or its
affiliates. Other names may be trademarks of their respective owners.
Intel and Intel Xeon are trademarks or registered trademarks of Intel
Corporation. All SPARC trademarks are used under license and are trademarks or
registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the
AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX
is a registered trademark of The Open Group.
This software or hardware and documentation may provide access to or
information about content, products, and services from third parties. Oracle Corporation
and its affiliates are not responsible for and expressly disclaim all warranties of any
kind with respect to third-party content, products, and services unless otherwise set
forth in an applicable agreement between you and Oracle. Oracle Corporation and its
affiliates will not be responsible for any loss, costs, or damages incurred due to your
access to or use of third-party content, products, or services, except as set forth in
an applicable agreement between you and Oracle.