Use of SDO_GEOM.SDO_INTERSECTION in INSERT AS SELECT does not Work in 11.2.0.4
Last updated on FEBRUARY 08, 2017
Applies to:
Oracle Spatial and Graph - Version 11.2.0.4 to 12.1.0.1 [Release 11.2 to 12.1]Information in this document applies to any platform.
Symptoms
The use of sdo_geom.sdo_intersection in a select to populate a table in
11.2.0.4 is not working properly. Example sql:
insert into
test_unit_lease_intersection
select /*+ ORDERED NOPARALLEL */ l.LEASE_NUMBER, L.TRACT_NUMBER, U.UNIT_ID,
(sdo_geom.sdo_area(sdo_geom.sdo_intersection(l.shape,u.shape,
0.05),0.05)/sdo_geom.sdo_area(l.shape,0.05)*100) pct_area_in_unit,
sdo_geom.sdo_intersection(l.shape,u.shape, 0.05) shape
from UNIT_BDRY u, GISCHK.LSE l
where sdo_anyinteract(l.shape, u.shape) = 'TRUE'
AND (sdo_geom.sdo_area(sdo_geom.sdo_intersection(l.shape,u.shape,
0.05),0.05)/sdo_geom.sdo_area(l.shape,0.05)*100) > 0.00099;
It does not return any error but just inserts NULL instead of calculated polygon.
Cause
Sign In with your My Oracle Support account |
|
Don't have a My Oracle Support account? Click to get started |
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms