[Gvsig_english] new problems with an oracle layer

[K.Kiss]

hello again,

Insert into GRUEN_POLY
   (OBJECTID,
    GE_CODE, TYP2, TYP3, GRUEN_GRUE, FLAECHE_HA,
    SHAPE, SE_ANNO_CAD_DATA, OGR_FID)
 Values
   (57, 1, 1, 1, 119264.494668,
    11.926449,
    "MDSYS"."SDO_GEOMETRY"(3007,31468,NULL,
    "MDSYS"."SDO_ELEM_INFO_ARRAY"(1,1003,1,193,2003,1),
   
"MDSYS"."SDO_ORDINATE_ARRAY"(4471575.00495711,5334345.4972686,0,4471600.50495291,5334341.99726918,0,4471805.00491925,5334312.99727395,0,4471782.50492295,5334238.99718613,0,4471774.50492427,5334193.49719362,0,4471779.50492344,5334191.99719387,0,4471786.50492229,5334235.99718663,0,4471809.5049185,5334310.99727428,0,4471813.50491785,5334311.4972742,0,4471826.50491571,5334332.99727066,0,4471988.00498912,5334308.99727461,0,4471985.00498961,5334286.49727831,0,4472054.50497817,5334276.49717996,0,4472058.50497751,5334275.99718004,0,4472067.00497611,5334274.49718029,0,4472227.50494969,5334251.99718399,0,4472215.50495167,5334128.99720424,0,4472225.0049501,5334124.49720498,0,4472372.0049259,5334102.49720861,0,4472373.00492574,5334108.99720753,0,4472389.50492302,5334106.49720795,0,4472394.5049222,5334108.99720753,0,4472395.50492203,5334111.49720712,0,4472394.5049222,5334125.99720474,0,4472236.00494829,5334148.49720103,0,4472251.00494582,5334266.49718161,0,4472249.00494615,5334278.99727955,0,4472252.50494557,5334299.99727609,0,4472259.0049445,5334313.49727387,0,4472277.50494146,5334328.4972714,0,4472301.50493751,5334333.99727049,0,4472354.00492886,5334327.49727156,0,4472422.00491767,5334318.49727304,0,4472428.00491668)),
NULL, 36)
    
Error at line 351
ORA-29875: Routine ODCIINDEXINSERT nicht erfolgreich ausgeführt
ORA-13034: Ungültige Daten in SDO_ORDINATE_ARRAY in Objekt SDO_GEOMETRY
ORA-06512: in "MDSYS.SDO_IDX", Zeile 161
ORA-06512: in "MDSYS.SDO_INDEX_METHOD_10I", Zeile 332
hello,

I´ve found maybe a data-problem, a few of data like 
"MDSYS"."SDO_GEOMETRY"(3007,31468,NULL,....   are in the database.

3007 is a MultiPolygon.........
----------------------------------------------------------------------------

the normal data case will work:

Insert into GRUEN_POLY
   (OBJECTID,
    GE_CODE, TYP2, TYP3, GRUEN_GRUE, FLAECHE_HA,
    SHAPE, SE_ANNO_CAD_DATA, OGR_FID)
 Values
   (22, 12, 3, 3, 4535.999797,
    0.4536,
    "MDSYS"."SDO_GEOMETRY"(3003,31468,NULL,
    "MDSYS"."SDO_ELEM_INFO_ARRAY"(1,1003,1),
   
"MDSYS"."SDO_ORDINATE_ARRAY"(4459968.99526779,5337888.99718524,0,4459967.99526795,5337895.49718417,0,4459968.49526787,5337900.49718335,0,4459971.49526738,5337906.49718236,0,4459973.99526696,5337911.49718154,0,4459977.49526639,5337919.99718014,0,4459982.49526556,5337928.99717866,0,4459985.99526499,5337936.49717742,0,4459990.49526425,5337945.49717594,0,4459993.99526367,5337952.49717479,0,4459997.99526301,5337960.99717339,0,4459999.99526268,5337966.49717248,0,4460000.4952626,5337975.99717092,0,4460001.49526244,5337989.49716869,0,4460001.49526244,5337998.99716713,0,4460000.99526252,5338007.49716573,0,4459999.99526268,5338017.997164,0,4459998.49526293,5338023.99716302,0,4459994.99526351,5338031.49716178,0,4459991.995264,5338036.99716087,0,4459987.99526466,5338043.99715972,0,4459983.99526532,5338048.9971589,0,4459980.49526589,5338053.99715808,0,4459975.99526663,5338059.49715717,0,4459972.49526721,5338063.49715651,0,4459967.99526795,5338068.99715561,0,4459963.99526861,5338073.99715478,0,4459960.9952691,5338078.99715396,0,4459957.49526968,5338084.99715297,0,4459954.99527009,5338091.4971519,0,4459953.49527034,5338097.99715083,0,4459952.99527042,5338103.49714993,0,4459952.99527042,5338109.99714886,0,4459953.49527034)),
NULL, 1)
/	


-----
Kornel Kiss

Referat für Gesundheit und Umwelt
Anforderungsmanagement Fachanwendungen
Bayerstr. 28a
80335 München
-- 
View this message in context: http://osgeo-org.1803224.n2.nabble.com/new-problems-with-an-oracle-layer-tp5190806p5203937.html
Sent from the gvSIG international mailing list archive at Nabble.com.