Spatial (MOSC)

MOSC Banner

Spatial and Locator in Oracle 11.2.0.3, Windows 2008 R2 64-bit

edited Nov 28, 2011 12:47AM in Spatial (MOSC) 2 comments
Did anybody test Oracle Spatial or Oracle Locator for the new version 11.2.0.3?

I found a significant difference:

Oracle Spatial - Enterprise Edition:

SQL> select sdo_geom.sdo_length(
  2  SDO_GEOMETRY(3002, null, NULL, SDO_ELEM_INFO_ARRAY(1, 2, 1),
  3  SDO_ORDINATE_ARRAY(0,0,0,1,0,0)),0.001) from dual;

SDO_GEOM.SDO_LENGTH(SDO_GEOMETRY(3002,NULL,NULL,SDO_ELEM_INFO_ARRAY(1,2,1),SDO_O
--------------------------------------------------------------------------------
                                                                               1

Oracle Locator - Standard Edition One

SQL> select sdo_geom.sdo_length(
  2  SDO_GEOMETRY(3002, null, NULL, SDO_ELEM_INFO_ARRAY(1, 2, 1),
  3  SDO_ORDINATE_ARRAY(0,0,0,1,0,0)),0.001) from dual;

SDO_GEOM.SDO_LENGTH(SDO_GEOMETRY(3002,NULL,NULL,SDO_ELEM_INFO_ARRAY(1,2,1),SDO_O
------------------------------------------------------------------------------

No result???

According to docuemtation:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center