Page 1 of 1

Access Violation with XMLTYPE and Unicode Environment

Posted: Tue 26 Jun 2018 08:51
by 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);

Re: Access Violation with XMLTYPE and Unicode Environment

Posted: Tue 03 Jul 2018 19:06
by heidenbluth
Could you reproduce the bug using the sample project I sent to your support account a week ago?

Re: Access Violation with XMLTYPE and Unicode Environment

Posted: Fri 06 Jul 2018 14:00
by 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.