When selecting or viewing from a table containing a Timestamp Datatype, Toad crashes with the error "Access violation" at address 00443B90 in module 'Toad.exe'.Read of address 0000003C" among others.
This happens in both the SQL Editor and the Schema Browser windows. It does not happen in SQL*Plus.
A bug in Oracle's 9i client is the cause of this issue. In order to support Unicode in Toad 10, we need to set certain flags in ODAC, which activates Unicode support in the OCI. The bug with the Oracle client is that when OCIUnicode = True, which is one of the flags that is needed to be set, it cannot convert a timestamp to string.
Upgrade your Oracle client to 10g or 11g. See further download information in Additional Information section below.
Oracle 10g Client
1) Vista and Windows 2008
Oracle Database 10g Client Release 2 (10.2.0.3) for Microsoft Windows Vista and Windows 2008
10203_vista_w2k8_x86_production_client.zip (616,757,461 bytes)
http://www.oracle.com/technology/software/products/database/oracle10g/htdocs/10203vista.html
2) XP, 2000, NT
Oracle Database 10g Client Release 2 (10.2.0.1.0) for Microsoft Windows (32-bit)
10201_client_win32.zip (475,090,051 bytes) (cksum - 946434250)
http://www.oracle.com/technology/software/products/database/oracle10g/htdocs/10201winsoft.html
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center