I am a long-time user of TOAD and love the tool very much.
Today it is giving me an issue - I am running TOAD 22.214.171.124 64-bit on my work windows laptop. Everything is working great except for querying against a particular table in a particular database.
The database is 126.96.36.199 (I know, ancient). The query is a simple select against this table below which does have one atypical column - that XMLTYPE.
SQL> desc rgdh.assay_detail
Name Null? Type
ASSAY_ID NOT NULL NUMBER(10)
ABBREVIATED_SUMMARY VARCHAR2(2000 CHAR)
FULL_SUMMARY VARCHAR2(4000 CHAR)
INFO_XML XMLTYPE STORAGE BINARY
As soon as I execute anything like
select* from rgdh.assay_detail;
select * from rgdh.assay_detail where assay_id = 40751;
TOAD throws the access violation and hangs.
I can do the query fine in SQL+ on the host server.
If I list the columns in TOAD, it works. It only fails on the select *. Weird, eh?
I see other similar issues where the suggestion is to load a newer oracle client (I’m running a 12c client, so I don’t think that’s the problem) or recreate my toad.ini (everything else works fine, so seems unlikely that is corrupted.
Suggestions welcome. Thanks.