Toad constantly crashes when querying tables with a lot of varchar2 (4000) columns. (4329071)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Toad constantly crashes when querying tables with a lot of varchar2 (4000) columns.
Description

Getting Access Violation errors when querying tables with a lot of varchar2 (4000) columns.
The error messages are like the one below:
[Error] Execution (8:21): Access violation at address 00007FF8E5A14B0C in module 'oracommon12.dll'. Write of address 0000000000000001
Cause

User files corrupted
Resolution

Reset the user settings:

1. Go to the Utilities Menu | Copy User Setting | Choose “Create a clean set of user files from base installation”.
2. Click OK to restart Toad.
3. This will reset Toad to factory defaults.

In case it is needed to revert back to your full previous setting:
1. Go to the Utilities Menu | Copy User Setting | Choose “Copy user files from a previous installation”
2. Click on the dropdown arrow to locate your "14.x_bak" folder (in C:\Users\>\AppData\Roaming\Quest Software\Toad for Oracle\14.1\) or use the ellipse button to locate it in your Toad directory.
3. Click OK to restart Toad.
4. This will reset Toad to the previous setting.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title