ODAC Direct Mode Bug: Selecting RAW columns through DB Link causes Access Violation
Hello,
Using ODAC version 12.3.0 and Delphi 11.3
Using ODAC with DIRECT=TRUE
TSmartQuery has Options.RawAsString=TRUE
I have a table like this:
CREATE TABLE HAS_RAW
(RAW_COL RAW(30));
Insert into HAS_RAW
(RAW_COL) Values ('43');
Insert into HAS_RAW
(RAW_COL) Values (NULL);
commit;
Select RAW_COL from HAS_RAW;
..then it works fine.
But if I connect to a different database that has a DB Link to the database with the HAS_RAW table, and change my query to:
Select RAW_COL from HAS_RAW@MY_DB_LINK;
...then I get an access violation.
This is very easy to reproduce. I don't think it matters but in my case, the database with the HAS_RAW table is 18c, and the database with the DB Link is 19c.
If I use an Oracle client instead of Direct Mode, there is no error.
Thanks
John