Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-13367 wrong orientation for interior/exterior rings

539040Jul 16 2008 — edited Jul 17 2008
I don't understand the following results. Why is one rectangle considered valid and there other is considered to have the wrong orientation? In my mind, they are both counter-clockwise. The only difference is that the first one is 2 degrees wider.

select sdo_geom.validate_geometry_with_context(sdo_geometry(2003,4326,null,sdo_elem_info_array(1,1003,1),sdo_ordinate_array(-90,-45 ,90,-45 ,90,45 ,-90,45 ,-90,-45)), 0.5) from dual;

RESULT: 13367 [Element <1>] [Ring <1>]

select sdo_geom.validate_geometry_with_context(sdo_geometry(2003,4326,null,sdo_elem_info_array(1,1003,1),sdo_ordinate_array(-89,-45 ,89,-45 ,89,45 ,-89,45 ,-89,-45)), 0.5) as x from dual;

RESULT: TRUE
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 14 2008
Added on Jul 16 2008
2 comments
7,194 views