I am trying to experiment with the new Map region by creating a map layer based on the OEHR_WAREHOUSES demo table:
CREATE TABLE "OEHR_WAREHOUSES"
( "WAREHOUSE_ID" NUMBER(3,0),
"WAREHOUSE_SPEC" "SYS"."XMLTYPE" ,
"WAREHOUSE_NAME" VARCHAR2(35),
"LOCATION_ID" NUMBER(4,0),
"WH_GEO_LOCATION" "MDSYS"."SDO_GEOMETRY" ,
CONSTRAINT "OEHR_WAREHOUSES_PK" PRIMARY KEY ("WAREHOUSE_ID")
USING INDEX ENABLE
)
In the layer definition, setting the Geometry Column Data Type attribute to SDO_GEOMETRY and selecting the WH_GEO_LOCATION column results in an error:
Layer → Warehouses → Column Mapping → Geometry Column
Wrong data type!
The data types of both the WAREHOUSE_SPEC (XMLTYPE) and WH_GEO_LOCATION (SDO_GEOMETRY) are reported as "ANYDATA" in the LOV values.