English
Bug Number NIM101461
Submitted May 07, 2014
Modified Jun 11, 2020
Severity Medium
Applies To No Product Found
Version Found 10.2
Prog Language N/A
Server Platform
Client Platform
Database All
Locale N/A
Status Implemented
Version Fixed 10.3.0
SP Fixed 10.3 Approved

Bug NIM101461

Synopsis

When feature classes with different SRIDs are used in an ST_intersection query, it fails with the message "ORA-06530: Reference to uninitialized composite."


Additional Information

N/A


Alternate Solution

Manually use 'st_transform':

SQL> SELECT SDE.ST_AsText(SDE.ST_Intersection(sde.st_transform(a.shape,300003), b.shape)) FROM ani3 a, ani4 b;

SDE.ST_ASTEXT(SDE.ST_INTERSECTION(SDE.ST_TRANSFORM(A.SHAPE,300003),B.SHAPE))
--------------------------------------------------------------------------------
POINT ( -117.38861502 34.41554692)