I am using
- Oracle 12.2.0.1.0
Windows 10
Delphi XE 10.3
ODAC 10.1.5
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);