ORA-00939: too many arguments for function
I have Oracle 10g and I would like to insert the geometry data into Oracle table.
If I insert less then 100 data, it's o.k.
For samo more data, I have error:
SQL> @E:/temp/koordinate.sql
INSERT INTO ZGS_KOORDINATE VALUES(535,535,MDSYS.SDO_GEOMETRY(2003,NULL,NULL,MDSYS.SDO_ELEM_INFO_ARRA
ERROR at line 1:
ORA-00939: too many arguments for function
Please help
Regards!
Hine
-------------------
INSERT INTO ZGS_KOORDINATE VALUES(535,535,MDSYS.SDO_GEOMETRY(2003,NULL,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(
489538.906, 82424.671,
489576.906, 82437.898,
489605.9301, 82445.703,
489657.4059, 82467.398,
489677.3121, 82480.109,
489736.312, 82514.843,
489787.8119, 82557.679,
489836.5001, 82593.812,
489866.8121, 82618.31,
489925.6869, 82665.976,
489967.906, 82707.23,
489987.812, 82718.132,
490014.3121, 82785.828,
490035.4059, 82817.671,
490069.93, 82889.937,
490086.687, 82926.921,
490122.593, 82963.46,
490131.406, 82981.289,
490132.593, 83033.671,
490138.5931, 83043.992,
490142.6871, 83081.25,
490150.906, 83143.648,
490163.312, 83158.62,
490171.187, 83200.828,
490180.4999, 83220.96,
490205.8119, 83271.132,
490211.6869, 83310.39,
490234.9299, 83360.46,
490321.8121, 83422.609,
490342.9999, 83436.921,
490347.9061, 83450.937,
490387.9299, 83487.78,
490443.5929, 83508.789,
490457.9059, 83510.976,
490515, 83514.25,
490550.906, 83526.46,
490566.9301, 83540.367,
490590.93, 83559.492,
490643.687, 83603.226,
490694.9999, 83654.976,
490697.9301, 83723.203,
490688.3121, 83778.39,
490692.3119, 83847.71,
490685.5931, 83871.351,
490691.593, 83900.93,
490716.5, 83959.976,
490731.593, 83965.882,
490750.9299, 83961.656,
490762.5931, 83970.968,
490769.93, 83994.906,
490759.3119, 84027.273,
490725.1869, 84070.62,
490713.406, 84106.429,
490711, 84145.992,
490727.5929, 84181.64,
490775.9061, 84269.656,
490770.906, 84272.39,
490798.1871, 84335.257,
490836.4061, 84361.476,
490844.3121, 84385.32,
490867.8119, 84409.742,
490899.93, 84421.14,
490908.9061, 84432.46,
490947, 84455.773,
490953.7535, 84460.4649,
490953.7535, 84460.465,
490968.906, 84470.992,
491012.9299, 84506.617,
491027.9299, 84512.921,
491061.1869, 84512.5,
491084.3119, 84508.679,
491120.3121, 84496.343,
491159.9059, 84471.78,
491190.906, 84445.311,
491216.5001, 84477,
491220.406, 84473.953,
491216.1871, 84502.632,
491224.5, 84568.601,
491245.5931, 84641.71,
491255.4059, 84669.953,
491256.5931, 84695.789,
491270.312, 84754.281,
491264.9999, 84820.101,
491267.906, 84867.968,
491260.3121, 84897.726,
491241.593, 84931.203,
491232.312, 84957.75,
491227.593, 84987.101,
491220.9059, 84999.601,
491204.4361, 85041.6677,
491201.3119, 85049.648,
491199.9999, 85082.109,
491182.3121, 85156.882,
491151.1871, 85195.82,
491136.3119, 85234.523,
491121.9999, 85305.78,
491134.6869, 85359.14,
491116.9059, 85407.757,
491102.9299, 85430.539,
491085.906, 85448.311,
491060.8121, 85513.851,
491011.4999, 85552.46,
491002.5, 85587.936,
490996.5931, 85635.936,
490987.6871, 85656.398,
490934.4999, 85710.921,
490934.9061, 85735.859,
490931, 85754.5,
490924.6869, 85765.531,
490909.9299, 85780.703,
490895.1869, 85819.593,
490886.812, 85832.14,
490878.5001, 85864.406,
490874.4061, 85894.968,
490894.5931, 85912.46,
490898.9059, 85938.686,
490900.906, 85968.531,
490906.4059, 85993.257,
490920.4999, 86027.492,
490922.6871, 86051.617,
490920.6871, 86074.273,
490928.4061, 86105.5,
490891, 86140.851,
490901.812, 86156.453,
490906.4059, 86189.796,
490934.312, 86252.343,
490936.5, 86258.436,
490946.406, 86260.218,
490953.593, 86280.742,
490957.1869, 86303.171,
490969, 86325.179,
490971.4059, 86348.21,
490965.5, 86371.968,
490969.687, 86418.132,
490988.6871, 86463.968,
491006.4061, 86509.296,
491028.812, 86548.21,
491057.0002, 86581.203,
491084.1871, 86612.492,
491085.687, 86620.703,
491048.4999, 86631.109,
491007.4059, 86661.561,
490989.187, 86678.226,
490977.812, 86688.367,
490966.812, 86706.828,
490956.906, 86712.561,
490948.8119, 86728.906,
490925.3119, 86758.218,
490893.8119, 86797.656,
490853.9061, 86858.656,
490858.9299, 86885.5,
490868.9301, 86916.23,
490850.4059, 86927.78,
490835.3119, 86939.742,
490857.4999, 86984.273,
490889.1867, 87041.289,
490926.3121, 87095.593,
490945.312, 87119.578,
490960.5929, 87133.867,
490921.1869, 87201.976,
490964.0001, 87225.218,
491021.906, 87269.561,
491049.9301, 87273.296,
491083.593, 87284.429,
491083.93, 87322.703,
491093.3121, 87325.781,
491112.687, 87337.953,
491121.4061, 87349.453,
491148.593, 87365.109,
491218.9299, 87386.679,
491233.406, 87386.851,
491247.9299, 87465.75,
491249.0001, 87490.686,
491259.4999, 87496.968,
491287.5929, 87505.23,
491348, 87519.398,
491402.5929, 87529.429,
491412.4059, 87535.867,
491411.4059, 87548.796,
491404.0001, 87569.46,
491392.0001, 87586.906,
491387.687, 87599.14,
491373.4059, 87622.406,
491367.9999, 87635.453,
491332.593, 87716.367,
491323.4999, 87777.289,
491319.593, 87812.62,
491349.8119, 87819.398,
491400.9061, 87841.421,
491499.3119, 87868.429,
491493.6871, 87909.311,
491475.1871, 87906.953,
491477.8121, 87960.843,
491492.312, 87959.898,
491492.4999, 87998.726,
491493.1869, 88017.148,
491535.6871, 88020.57,
491550.4061, 88026.859,
491532.8123, 88058.679,
491501.9301, 88082.311,
491471.3121, 88110.953,
491436.687, 88165.468,
491384.3119, 88222.226,
491342.593, 88257.71,
491301.187, 88282.96,
491285.312, 88299.843,
491261.406, 88359.546,
491263.5, 88470.546,
491266.593, 88485.281,
491293.9301, 88553.32,
491315.593, 88585.156,
491326.5, 88629.757,
491322.5931, 88652.632,
491324.312, 88690.328,
491326.187, 88706.7,
491312.5929, 88736.781,
491260.4999, 88776.62,
491266.9999, 88786.507,
491281.5001, 88786.578,
491286.9061, 88791.78,
491350.9299, 88800.281,
491368.187, 88807.867,
491360.9061, 88829.14,
491352.812, 88936.953,
491340.5, 89021.609,
491338.406, 89047.789,
491343.9999, 89102.93,
491348.1121, 89102.7399,
491345.6206, 89103.9499,
491335.0465, 89179.0464,
491314.473, 89278.7666,
491345.31, 89347.7939,
491413.2385, 89460.4374,
491513.7672, 89607.8336,
491632.2609, 89790.0493,
491653.8588, 89930.8243,
491663.81, 90175.7209,
491694.0041, 90691.4842,
491758.4448, 90881.5605,
491803.4465, 90985.4977,
491871.7651, 91028.4312,
491954.5374, 91056.443,
492061.1081, 91166.9934,
492151.0756, 91336.0265,
492226.1659, 91486.7114,
492396.8812, 91733.0072,
492527.6578, 91760.3174,
492607.6931, 91859.855,
492590.1374, 91969.1649,
492625.2789, 92055.0449,
492617.4923, 92263.9014,
492516.6435, 92458.1772,
492422.3385, 92582.0895,
492369.6485, 92679.6922,
492322.8164, 92804.6213,
492268.1729, 92886.6089,
492109.1618, 93148.5326,
492096.6842, 93212.8292,
492035.3419, 93311.7958,
492029.4141, 93408.7759,
491968.0646, 93432.5339,
491951.9969, 93501.4289,
491948.782, 93501.2851,
491942.658, 93547.2254,
491950.4596, 93582.3274,
491966.1049, 93630.4513,
491995.7936, 93654.1976,
492032.66, 93640.315,
492093.5396, 93663.8698,
492175.5388, 93677.3396,
492291.9605, 93731.5664,
492385.8254, 93715.2094,
492532.5216, 93646.6439,
492644.4266, 93626.4635,
492745.7058, 93575.398,
492776.1221, 93466.9109,
492694.0889, 93341.2395,
492686.1351, 93175.8696,
492728.4511, 92997.2638,
492811.7366, 92869.9366,
492883.1973, 92640.0429,
492896.4089, 92461.4406,
493036.6314, 92395.2743,
493205.9392, 92133.3051,
493363.3526, 91997.0193,
493363.3451, 91920.2872,
493768.1373, 91712.5295,
493937.3965, 91680.086,
493969.4169, 91429.2875,
493916.6934, 91269.35,
493921.6616, 91104.8575,
493904.202, 90960.3064,
493936.5864, 90813.2565,
493930.6684, 90709.7263,
493938.9597, 90541.4823,
493896.3727, 90455.2893,
493880.0136, 90425.174,
493856.1199, 90341.0556,
493832.2297, 90293.286,
493852.9846, 90138.5414,
493822.8575, 90028.4605,
493763.6568, 89965.1174,
493754.3042, 89902.8064,
493813.4929, 89846.7178,
493825.9515, 89811.406,
493840.4857, 89763.6314,
493880.0519, 89728.0575,
493914.3726, 89710.3254,
493951.3309, 89664.6812,
493974.6283, 89615.9741,
493979.8002, 89573.5264,
494039.8353, 89473.0949,
494064.9931, 89370.9238,
494071.5191, 89258.6858,
493986.6802, 89077.2779,
493918.8091, 88987.2264,
493896.6201, 88851.4966,
493886.1785, 88706.6313,
493873.9998, 88585.656,
493863.4951, 88515.4107,
493831.743, 88496.3641,
493831.7367, 88431.2741,
493883.4611, 88428.1896,
493922.5899, 88406.578,
493929.9101, 88318.7891,
493960.3098, 88282.0269,
493910.8366, 88209.2331,
493944.7699, 88183.1235,
493916.0496, 88128.306,
493986.5268, 88083.918,
494197.9636, 88000.3539,
494271.4282, 87964.475,
494317.4596, 87902.5543,
494250.7771, 87824.7722,
494236.4712, 87639.0296,
494296.7861, 87534.2429,
494369.811, 87532.646,
494449.1838, 87511.9975,
494550.7836, 87508.8093,
494677.779, 87461.1662,
494692.0595, 87392.8993,
494668.68, 87331.612,
494783.5698, 87245.9428,
494888.0109, 87128.9379,
494982.0037, 86980.5974,
495111.5104, 86830.1633,
495201.3326, 86759.1211,
495328.758, 86690.1634,
495516.7659, 86619.1088,
495261.1225, 86346.8995,
495211.0585, 86235.5013,
495238.5372, 86123.6355,
495304.9433, 86028.1489,
495345.6895, 85883.9175,
495352.6334, 85721.4375,
495295.1289, 85551.252,
495236.3839, 85475.0566,
495198.2461, 85328.7097,
495176.0363, 85244.8683,
495137.93, 85182.9583,
495045.849, 85121.0553,
494953.7625, 85005.1751,
494945.8183, 84933.736,
494942.643, 84932.1487,
494826.7555, 84932.1636,
494637.8372, 84871.8606,
494498.1909, 84767.1064,
494410.8845, 84730.5935,
494368.4976, 84747.0394,
494302.4326, 84757.8685,
494231.6057, 84666.1679,
494160.5282, 84606.853,
494150.71, 84566.6224,
494026.1176, 84571.9286,
493996.2271, 84527.8101,
494005.7448, 84451.606,
493973.3617, 84351.9779,
494029.5464, 84342.0614,
494129.5609, 84364.2744,
494181.947, 84349.9795,
494208.9317, 84322.9876,
494182.3601, 84268.6598,
494178.7608, 84235.6756,
494234.3136, 84137.2397,
494270.8101, 83973.7164,
494205.7172, 83918.1601,
494197.7761, 83881.6472,
493912.0127, 83746.7414,
493886.5978, 83592.7513,
493913.5652, 83391.1276,
493950.0582, 83192.678,
494131.0146, 83000.5599,
494235.7806, 82910.0555,
494299.2681, 82781.455,
494342.1271, 82748.1108,
494354.8208, 82681.4316,
494405.6156, 82630.6231,
494440.531, 82530.6024,
494504.9113, 82511.4523,
494545.3061, 82533.764,
494581.817, 82517.8837,
494611.9659, 82378.1746,
494577.0379, 82348.0154,
494675.4374, 82087.6429,
494816.7172, 82011.4219,
494918.3155, 81992.3581,
495116.7526, 81987.57,
495216.7669, 82005.0203,
495238.9949, 82038.3563,
495294.552, 81981.1969,
495346.9235, 81819.259,
495427.8749, 81706.5319,
495518.3415, 81493.7871,
495494.5219, 81420.7625,
495626.2805, 81382.6441,
495704.0656, 81358.8208,
495713.1095, 81314.6534,
495712.2137, 81253.7393,
495709.382, 81175.8325,
495718.3952, 81044.4945,
495759.6813, 80977.8265,
495805.7282, 80919.0955,
495864.9999, 80785,
495517.0695, 80768.2359,
495412.2924, 80780.9309,
495375.7845, 80752.3568,
495308.305, 80754.3331,
495225.0001, 80750.9999,
495191.9999, 80715,
495181, 80665.9999,
495139.2674, 80628.5328,
495114.9999, 80562,
495003, 80489,
494910.6926, 80476.1365,
494878.9377, 80504.7079,
494820.2005, 80503.1184,
494791.0276, 80469.4375,
494675.6301, 80356.6259,
494645.6056, 80318.9766,
494640.8493, 80282.4669,
494472.0001, 80192,
494411.9999, 80185,
494329.9998, 80101,
494328.1613, 79980.8544,
494256.7311, 79934.8179,
494196.3991, 79977.6746,
494134.4866, 79979.2596,
494080.535, 79836.3943,
494028.1616, 79750.6741,
493982.1146, 79807.8178,
493880.4952, 79925.2794,
493623, 80231,
493575.0001, 80265,
493539.9999, 80251,
493519, 80278,
493452, 80294,
493394.6605, 80290.3561,
493378.7816, 80312.5788,
493212.0882, 80349.082,
492827.8983, 80441.1349,
492410.3691, 80542.7106,
492019.828, 80639.5254,
491870.5978, 80672.8545,
491818.2068, 80693.4882,
491827.739, 80649.0423,
491818.2175, 80628.4061,
491770.2591, 80536.3143,
491697.6031, 80410.9316,
491627.7701, 80307.7499,
491588.0918, 80252.1904,
491454.7296, 80325.2044,
491273.0001, 80415.9999,
491272.1564, 80390.2796,
491096.7799, 80435.6739,
490985.8856, 80514.3102,
490921.2913, 80560.1149,
490866, 80605,
490751.1924, 80665.9298,
490750.9417, 80665.7331,
490726, 80782.5,
490720.593, 80857.7,
490575.812, 80930.273,
490433.906, 81005.437,
490392.4061, 81027.617,
490335.6871, 81046.796,
490336, 81053.7,
490366.9059, 81177.93,
490392.812, 81228.343,
490394.4061, 81283.351,
490407.9999, 81363.882,
490489.9298, 81469.64,
490485.9999, 81489.757,
490458.5, 81504.851,
490399.5931, 81520.531,
490366.3121, 81530.929,
490330.1871, 81555.7,
490316.1871, 81569.328,
490269.4999, 81586.976,
490225.4061, 81630.281,
490212.812, 81649.648,
490153, 81725.648,
490125.8119, 81777.429,
490113.9061, 81789.781,
490104.9998, 81805.437,
490097.593, 81835.82,
490084.1867, 81855.89,
490078.812, 81878.648,
490066.3121, 81899.132,
490071.593, 81939.203,
490049.312, 81959.992,
490018.906, 81974.796,
489983.5931, 81999.796,
489959.9299, 82025.492,
489928.8121, 82033.218,
489918, 82044.453,
489886.906, 82069.812,
489875.687, 82084.242,
489869.3121, 82086.25,
489837.1871, 82106.898,
489813.4059, 82143.976,
489799.8121, 82156.101,
489796.6869, 82193.273,
489779.5, 82220.921,
489749.312, 82246.578,
489703.812, 82286.78,
489682.9301, 82291.5,
489644.1871, 82310.148,
489630.1869, 82326.789,
489599.6873, 82364.273,
489579.5931, 82379.101,
489575.4061, 82387.648,
489561.93, 82402.75,
489538.906, 82424.671)));