Use of SDO_GEOM.SDO_INTERSECTION in INSERT AS SELECT does not Work in 11.2.0.4 (Doc ID 2041414.1)

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