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!

Opinions? Do you let 2003s camp out in spacious 2007s?

matt schellNov 10 2009 — edited Nov 19 2009
Hi Everyone,

Just out of curiosity, am I the only one late to the game in discovering that the definition of sdo_gtype 2007 allows single polygons, what I would call a "2003" to validly live inside a geometry defined as sdo_gtype 2007? When you see a gtype of 2007 in a geometry do you absolutely expect a multipolyon, or does your shop follow the documentation:

"Geometry can have multiple, disjoint polygons (more than one exterior boundary). (MULTIPOLYGON is a superset of POLYGON.) "
http://download.oracle.com/docs/html/B14255_01/sdo_objrelschema.htm#sthref208

That word "can" in the documentation is a sticky one. Looks like this guy has been wondering about this since (the year) 2003 , but I don't see any other discussion:
See: 451394

It's not a big deal to switch all sdo_gtype code to sdo_util.getnumelem when this sort of thing matters. Like I said, just curious if anyone enforces internal standards that are a little more strict than the documentation.

Thanks in advance for your opinions,
Matt
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 17 2009
Added on Nov 10 2009
9 comments
1,879 views