Use of SDO_GEOM.SDO_INTERSECTION in INSERT AS SELECT does not Work in 220.127.116.11
(Doc ID 2041414.1)
Last updated on FEBRUARY 08, 2017
Oracle Spatial and Graph - Version 18.104.22.168 to 22.214.171.124 [Release 11.2 to 12.1]
Information in this document applies to any platform.
The use of sdo_geom.sdo_intersection in a select to populate a table in
126.96.36.199 is not working properly. Example sql:
select /*+ ORDERED NOPARALLEL */ l.LEASE_NUMBER, L.TRACT_NUMBER, U.UNIT_ID,
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'
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.
|This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.|