0 Replies Latest reply: Jun 25, 2012 12:40 PM by bruarm RSS

    geometry validation 10g vs 11g (ora-13351)

    bruarm
      Just wondering why this validates in 10g, but returns ora-13351 in 11g (which is correct)? From what I read, it should also fail in 10g...

      11g environment:
      Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
      PL/SQL Release 11.2.0.3.0 - Production
      CORE     11.2.0.3.0     Production

      10g environment:
      Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
      PL/SQL Release 10.2.0.4.0 - Production
      CORE     10.2.0.4.0     Production

      SELECT
      SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT(
      SDO_GEOMETRY(
      2007,
      NULL,
      NULL,
      SDO_ELEM_INFO_ARRAY(1, 1003, 1, 9, 1003, 1),
      SDO_ORDINATE_ARRAY(36753.8478764536, 5936814.20330738, 36754.3637490109, 5936815.23514135, 36753.8863847024, 5936814.33145903, 36753.8478764536, 5936814.20330738, 36917.6835060459, 5936621.04457117, 36910.9061876956, 5936620.53880114, 36906.3542574604, 5936621.14572517, 36901.3977112043, 5936623.87688331, 36894.4878276682, 5936631.08624302, 36872.1642036936, 5936658.16809109, 36841.3122320993, 5936694.38122496, 36824.4145114155, 5936716.05334691, 36818.0090915069, 5936726.54733272, 36808.1965333491, 5936749.57958728, 36798.9291173111, 5936771.79412867, 36775.7605772162, 5936827.53491043, 36775.2103967376, 5936829.23276669, 36773.6349817623, 5936831.10203047, 36772.4897244969, 5936831.89604738, 36770.9723339901, 5936832.2221241, 36769.2188717776, 5936832.30490397, 36767.5012211379, 5936831.61847453, 36762.5028798447, 5936827.97781022, 36760.6507830196, 5936826.1541382, 36757.6285112693, 5936822.32228049, 36755.5126616402, 5936818.57436884, 36753.4300334271, 5936812.65295722, 36752.7013235202, 5936808.07832683, 36761.0971059541, 5936791.08445395, 36768.3801943304, 5936776.31596919, 36775.9667447225, 5936761.14286841, 36788.9693838113, 5936737.70894554, 36810.7637225207, 5936705.71047354, 36823.2056651636, 5936687.19929059, 36843.03879012, 5936658.05344964, 36891.1652177631, 5936592.7082915, 36939.2100330225, 5936549.13161968, 36951.530217724, 5936530.0353334, 36970.0104947763, 5936536.50343037, 36966.9304486009, 5936541.12349963, 36953.7696167838, 5936571.31940278, 36951.6035541326, 5936577.81759074, 36945.9529559121, 5936583.09148241, 36944.2732150702, 5936586.8708993, 36938.4188249514, 5936600.04327707, 36932.1995321217, 5936614.72080815, 36929.0011612507, 5936622.26896341, 36919.9602040979, 5936623.0223765, 36917.6835060459, 5936621.04457117)
      ),
      0.0001
      ) result
      FROM
      dual;

      Thanks for any thoughts/opinions!!