Access Violation with XMLTYPE and Unicode Environment

[heidenbluth]

Hello,

I am using

• Oracle 12.2.0.1.0
  Windows 10
  Delphi XE 10.3
  ODAC 10.1.5

When I open an XMLTYPE table using a TSmartQuery component, I get an access violation error, if the Unicode Environment has been enabled.

Code: Select all

CREATE TABLE warehouses(
  warehouse_id NUMBER(4),
  warehouse_spec XMLTYPE,
  warehouse_name VARCHAR2(35),
  location_id NUMBER(4));
 
INSERT INTO warehouses VALUES 
   (       100, XMLType(
              '<Warehouse whNo="100"> 
               <Building>Owned</Building>
               </Warehouse>'), 'Tower Records', 1003);

[heidenbluth]

Could you reproduce the bug using the sample project I sent to your support account a week ago?

[bork]

Hello

We investigated this issue several years ago and it looks like Oracle client bug. You shouldn't use Unicode Environment, but you can use the Direct mode, which allows using XML with Unicode Environment without any errors.