Discussion :

[yanos_5]

Bonjour,

Voilà la situation :

Je tente d'insérer une forme géométrique de type polygone dans une base de données Oracle 9.2i. A l'exécution de cette requête un message d'erreur ORA - 00939 too many arguments apparaît.

Si je réduit le nombre de points de mon polygone, l'insertion fonctionne.

Je me demande donc si ce ne serait pas un problème de taille du tampon de réception de ORACLE de la requête SQL et si il serait possible d'augmenter cette taille...

Merci d'avance

[philcero]

Le nombre de points d'un polygone est limité à 999. Quel est le langage que tu utilises ?

[yanos_5]

La requête est en sql et j'essaye de l'exécuter avec SqlDevelopper et Sql Plus.

voici la requête peut être que quelque chose m'échappe :

INSERT INTO entities VALUES ( 13791,NULL, 6, 29, 0, 5, -1,MDSYS.SDO_GEOMETRY(3003,41014,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(860016.500000,2084194.300000,0.0,860016.800000,2084189.400000,0.0,860017.500000,2084180.200000,0.0,860019.500000,2084128.100000,0.0,860020.300000,2084104.200000,0.0,860020.400000,2084102.500000,0.0,860020.600000,2084094.400000,0.0,860022.000000,2084048.400000,0.0,860024.100000,2083986.800000,0.0,860024.600000,2083967.400000,0.0,860026.000000,2083934.300000,0.0,860026.900000,2083909.600000,0.0,860028.800000,2083866.300000,0.0,860030.900000,2083810.500000,0.0,860033.100000,2083760.300000,0.0,860034.100000,2083732.000000,0.0,860035.300000,2083686.500000,0.0,860037.400000,2083616.900000,0.0,860037.800000,2083604.400000,0.0,860038.200000,2083594.500000,0.0,860041.800000,2083497.700000,0.0,860043.700000,2083422.100000,0.0,860046.600000,2083343.900000,0.0,860049.100000,2083282.500000,0.0,860050.800000,2083244.700000,0.0,860050.900000,2083241.900000,0.0,860051.100000,2083235.000000,0.0,860053.100000,2083147.500000,0.0,860055.600000,2083070.400000,0.0,860058.800000,2082962.500000,0.0,860061.200000,2082891.300000,0.0,860053.000000,2082873.000000,0.0,860049.800000,2082868.800000,0.0,860045.300000,2082865.900000,0.0,860023.000000,2082860.800000,0.0,859991.600000,2082855.600000,0.0,859976.500000,2082852.200000,0.0,859956.900000,2082849.200000,0.0,859934.600000,2082847.900000,0.0,859903.800000,2082847.400000,0.0,859845.800000,2082843.700000,0.0,859806.800000,2082844.600000,0.0,859750.400000,2082844.300000,0.0,859726.500000,2082845.100000,0.0,859708.900000,2082847.900000,0.0,859675.600000,2082856.300000,0.0,859538.400000,2082897.200000,0.0,859518.400000,2082903.200000,0.0,859514.700000,2082888.600000,0.0,859510.900000,2082873.300000,0.0,859504.100000,2082856.000000,0.0,859501.700000,2082849.700000,0.0,859487.100000,2082809.900000,0.0,859480.300000,2082793.700000,0.0,859450.000000,2082730.000000,0.0,859330.000000,2082545.000000,0.0,859285.000000,2082510.000000,0.0,859240.300000,2082499.800000,0.0,859236.500000,2082563.700000,0.0,859217.800000,2082690.800000,0.0,859211.500000,2082769.300000,0.0,859210.000000,2082795.000000,0.0,859140.000000,2082725.000000,0.0,858920.000000,2082545.000000,0.0,858890.000000,2082530.000000,0.0,858855.000000,2082690.000000,0.0,858775.000000,2082790.000000,0.0,858700.000000,2082925.000000,0.0,858645.000000,2082975.000000,0.0,858620.000000,2083015.000000,0.0,858585.000000,2083065.000000,0.0,858505.000000,2083095.000000,0.0,858475.000000,2083125.000000,0.0,858385.000000,2083180.000000,0.0,858310.000000,2083190.000000,0.0,858115.000000,2083305.000000,0.0,858047.000000,2083372.900000,0.0,858045.000000,2083375.000000,0.0,857970.000000,2083485.000000,0.0,857885.000000,2083585.000000,0.0,857825.000000,2083630.000000,0.0,857780.000000,2083670.000000,0.0,857760.000000,2083795.000000,0.0,857730.000000,2083845.000000,0.0,857700.000000,2083870.000000,0.0,857655.000000,2083885.000000,0.0,857600.000000,2083880.000000,0.0,857540.000000,2083840.000000,0.0,857410.000000,2083935.000000,0.0,857304.300000,2084009.100000,0.0,857217.800000,2084075.300000,0.0,857055.000000,2084205.000000,0.0,857005.600000,2084244.700000,0.0,856940.300000,2084277.700000,0.0,856880.000000,2084315.000000,0.0,856852.700000,2084323.200000,0.0,856790.000000,2084355.000000,0.0,856715.000000,2084300.000000,0.0,856690.100000,2084295.900000,0.0,856674.900000,2084336.200000,0.0,856656.200000,2084334.900000,0.0,856620.000000,2084410.000000,0.0,856597.000000,2084499.700000,0.0,856596.400000,2084502.200000,0.0,856547.000000,2084498.600000,0.0,856501.400000,2084509.300000,0.0,856465.000000,2084535.000000,0.0,856435.000000,2084585.000000,0.0,856421.600000,2084632.200000,0.0,856405.000000,2084660.000000,0.0,856326.600000,2084821.000000,0.0,856290.500000,2084940.400000,0.0,856252.500000,2084945.700000,0.0,856245.000000,2084985.000000,0.0,856317.400000,2085096.300000,0.0,856272.500000,2085165.700000,0.0,856250.000000,2085240.000000,0.0,856239.200000,2085300.000000,0.0,856351.300000,2085300.000000,0.0,856391.500000,2085353.100000,0.0,856423.300000,2085384.900000,0.0,856477.900000,2085412.800000,0.0,856538.800000,2085403.100000,0.0,856563.100000,2085410.900000,0.0,856591.400000,2085428.400000,0.0,856634.100000,2085451.600000,0.0,856665.000000,2085475.000000,0.0,856660.600000,2085486.300000,0.0,856664.300000,2085523.800000,0.0,856699.800000,2085543.100000,0.0,856719.900000,2085595.600000,0.0,856758.600000,2085677.300000,0.0,856773.900000,2085677.500000,0.0,856801.500000,2085678.000000,0.0,856822.700000,2085682.500000,0.0,856831.100000,2085698.100000,0.0,856823.400000,2085823.300000,0.0,856816.500000,2085876.500000,0.0,856806.100000,2085993.200000,0.0,856813.100000,2086070.400000,0.0,856833.100000,2086126.100000,0.0,856860.100000,2086164.400000,0.0,856895.300000,2086184.500000,0.0,856898.800000,2086240.200000,0.0,856900.900000,2086273.200000,0.0,856902.500000,2086297.000000,0.0,856902.800000,2086302.900000,0.0,856904.100000,2086317.000000,0.0,856908.600000,2086363.900000,0.0,856918.900000,2086469.900000,0.0,856936.500000,2086581.900000,0.0,856943.500000,2086626.100000,0.0,856935.300000,2086628.300000,0.0,856910.300000,2086635.200000,0.0,856926.900000,2086954.600000,0.0,856974.200000,2087085.800000,0.0,857000.500000,2087208.400000,0.0,857086.800000,2087264.700000,0.0,857134.600000,2087334.800000,0.0,857183.700000,2087417.100000,0.0,857219.700000,2087515.700000,0.0,857235.000000,2087545.000000,0.0,857153.900000,2087595.500000,0.0,857155.800000,2087694.000000,0.0,857126.100000,2087825.700000,0.0,857094.300000,2087941.200000,0.0,857089.800000,2088075.300000,0.0,857154.300000,2088123.000000,0.0,857126.800000,2088167.500000,0.0,857085.600000,2088249.500000,0.0,857076.800000,2088309.300000,0.0,857059.300000,2088366.700000,0.0,857049.300000,2088428.800000,0.0,857035.600000,2088481.600000,0.0,857049.400000,2088505.500000,0.0,857058.600000,2088539.000000,0.0,857088.200000,2088658.800000,0.0,857106.500000,2088660.200000,0.0,857149.100000,2088662.400000,0.0,857156.700000,2088722.300000,0.0,857148.300000,2088770.000000,0.0,857162.000000,2088822.100000,0.0,857172.600000,2088860.600000,0.0,857200.700000,2088929.000000,0.0,857215.900000,2089002.500000,0.0,857232.100000,2089060.600000,0.0,857218.300000,2089107.500000,0.0,857204.600000,2089137.900000,0.0,857192.400000,2089213.500000,0.0,857215.000000,2089265.000000,0.0,857215.000000,2089320.000000,0.0,857206.800000,2089405.200000,0.0,857206.100000,2089446.600000,0.0,857231.200000,2089505.800000,0.0,857247.900000,2089566.400000,0.0,857290.500000,2089584.200000,0.0,857285.100000,2089670.500000,0.0,857302.600000,2089732.500000,0.0,857319.400000,2089810.200000,0.0,857368.800000,2089971.300000,0.0,857439.500000,2090128.900000,0.0,857500.000000,2090170.000000,0.0,857533.400000,2090219.900000,0.0,857558.200000,2090220.600000,0.0,857564.800000,2090219.300000,0.0,857570.400000,2090217.200000,0.0,857573.600000,2090215.300000,0.0,857576.600000,2090210.800000,0.0,857578.000000,2090207.300000,0.0,857579.800000,2090198.100000,0.0,857589.800000,2090167.900000,0.0,857633.000000,2090083.800000,0.0,857648.900000,2090067.600000,0.0,857656.800000,2090059.600000,0.0,857675.100000,2090041.100000,0.0,857714.400000,2090037.600000,0.0,857741.300000,2090029.400000,0.0,857789.400000,2090008.300000,0.0,857851.900000,2089973.700000,0.0,857876.300000,2089965.500000,0.0,857903.200000,2089962.000000,0.0,857955.100000,2089963.200000,0.0,858006.900000,2089964.900000,0.0,858031.900000,2089962.600000,0.0,858083.500000,2089947.200000,0.0,858092.700000,2089944.500000,0.0,858198.300000,2089914.600000,0.0,858230.200000,2089884.700000,0.0,858211.600000,2089835.500000,0.0,858201.200000,2089807.700000,0.0,858199.800000,2089799.200000,0.0,858200.500000,2089791.200000,0.0,858209.600000,2089779.800000,0.0,858222.100000,2089759.300000,0.0,858225.800000,2089744.100000,0.0,858222.100000,2089724.200000,0.0,858218.300000,2089716.000000,0.0,858210.900000,2089700.900000,0.0,858204.600000,2089694.900000,0.0,858194.000000,2089690.300000,0.0,858187.200000,2089687.300000,0.0,858178.100000,2089679.800000,0.0,858168.300000,2089666.400000,0.0,858151.700000,2089644.400000,0.0,858150.300000,2089611.500000,0.0,858150.900000,2089575.100000,0.0,858155.900000,2089559.900000,0.0,858162.800000,2089551.700000,0.0,858182.200000,2089541.700000,0.0,858194.700000,2089530.600000,0.0,858212.800000,2089503.600000,0.0,858227.800000,2089463.800000,0.0,858230.300000,2089443.300000,0.0,858241.500000,2089424.500000,0.0,858253.400000,2089409.300000,0.0,858272.200000,2089393.500000,0.0,858284.000000,2089382.400000,0.0,858291.500000,2089366.500000,0.0,858294.000000,2089356.600000,0.0,858292.000000,2089326.700000,0.0,858287.000000,2089299.200000,0.0,858287.000000,2089295.100000,0.0,858280.200000,2089257.600000,0.0,858272.000000,2089231.800000,0.0,858266.400000,2089220.100000,0.0,858267.000000,2089201.900000,0.0,858262.600000,2089155.500000,0.0,858242.700000,2089144.300000,0.0,858235.600000,2089139.300000,0.0,858231.700000,2089132.700000,0.0,858229.700000,2089125.700000,0.0,858222.700000,2089111.300000,0.0,858219.800000,2089102.800000,0.0,858260.000000,2089045.000000,0.0,858283.500000,2089010.400000,0.0,858287.900000,2088998.900000,0.0,858288.400000,2088985.200000,0.0,858287.600000,2088972.500000,0.0,858286.500000,2088957.200000,0.0,858284.200000,2088947.900000,0.0,858284.900000,2088915.200000,0.0,858288.700000,2088891.800000,0.0,858308.000000,2088870.000000,0.0,858360.000000,2088860.000000,0.0,858370.000000,2088850.000000,0.0,858370.000000,2088790.000000,0.0,858380.100000,2088767.700000,0.0,858384.600000,2088744.000000,0.0,858388.500000,2088735.800000,0.0,858391.900000,2088731.500000,0.0,858398.700000,2088728.000000,0.0,858406.800000,2088726.400000,0.0,858413.900000,2088727.500000,0.0,858428.900000,2088732.900000,0.0,858435.500000,2088733.200000,0.0,858455.900000,2088735.700000,0.0,858460.700000,2088734.300000,0.0,858466.500000,2088730.500000,0.0,858471.900000,2088724.300000,0.0,858482.900000,2088710.800000,0.0,858489.100000,2088700.300000,0.0,858492.400000,2088692.900000,0.0,858496.100000,2088681.400000,0.0,858496.900000,2088673.800000,0.0,858497.200000,2088664.500000,0.0,858500.000000,2088645.600000,0.0,858502.700000,2088630.400000,0.0,858502.700000,2088621.300000,0.0,858500.500000,2088614.700000,0.0,858494.600000,2088606.400000,0.0,858492.600000,2088600.700000,0.0,858491.200000,2088592.600000,0.0,858491.100000,2088580.200000,0.0,858491.300000,2088565.000000,0.0,858492.900000,2088559.400000,0.0,858497.100000,2088552.300000,0.0,858509.000000,2088537.800000,0.0,858519.600000,2088527.600000,0.0,858530.800000,2088521.100000,0.0,858539.700000,2088513.600000,0.0,858572.500000,2088502.300000,0.0,858582.500000,2088483.600000,0.0,858583.700000,2088447.200000,0.0,858577.500000,2088425.000000,0.0,858577.500000,2088396.800000,0.0,858582.500000,2088387.500000,0.0,858587.500000,2088379.300000,0.0,858615.000000,2088368.700000,0.0,858642.500000,2088359.300000,0.0,858655.000000,2088350.000000,0.0,858661.200000,2088337.100000,0.0,858661.200000,2088320.700000,0.0,858652.500000,2088308.900000,0.0,858640.500000,2088303.100000,0.0,858633.400000,2088300.900000,0.0,858626.100000,2088300.800000,0.0,858605.600000,2088304.200000,0.0,858589.800000,2088314.100000,0.0,858583.800000,2088319.500000,0.0,858577.700000,2088324.000000,0.0,858568.900000,2088335.500000,0.0,858560.600000,2088340.600000,0.0,858554.500000,2088340.700000,0.0,858548.300000,2088339.700000,0.0,858542.500000,2088336.000000,0.0,858538.600000,2088330.900000,0.0,858536.200000,2088320.700000,0.0,858526.200000,2088273.800000,0.0,858531.200000,2088248.000000,0.0,858545.000000,2088222.200000,0.0,858555.000000,2088194.100000,0.0,858556.200000,2088167.200000,0.0,858548.700000,2088134.300000,0.0,858535.000000,2088105.000000,0.0,858535.000000,2088095.700000,0.0,858546.200000,2088069.900000,0.0,858555.000000,2088067.500000,0.0,858565.000000,2088062.900000,0.0,858572.500000,2088050.000000,0.0,858580.000000,2088032.400000,0.0,858593.700000,2088019.500000,0.0,858597.500000,2088011.300000,0.0,858597.500000,2087997.200000,0.0,858592.500000,2087979.700000,0.0,858582.500000,2087958.500000,0.0,858572.800000,2087928.200000,0.0,858553.100000,2087897.500000,0.0,858547.500000,2087888.900000,0.0,858540.000000,2087877.300000,0.0,858534.500000,2087860.100000,0.0,858527.500000,2087825.000000,0.0,858525.900000,2087811.100000,0.0,858521.700000,2087773.700000,0.0,858520.000000,2087763.100000,0.0,858519.800000,2087761.800000,0.0,858517.800000,2087749.400000,0.0,858516.600000,2087741.200000,0.0,858514.600000,2087707.100000,0.0,858514.400000,2087704.000000,0.0,858514.200000,2087698.600000,0.0,858506.000000,2087679.000000,0.0,858500.900000,2087655.600000,0.0,858489.500000,2087610.700000,0.0,858480.400000,2087587.400000,0.0,858466.600000,2087556.100000,0.0,858460.100000,2087542.000000,0.0,858457.400000,2087510.700000,0.0,858454.600000,2087493.800000,0.0,858459.700000,2087447.200000,0.0,858472.400000,2087411.500000,0.0,858473.700000,2087378.000000,0.0,858445.600000,2087339.600000,0.0,858435.100000,2087295.700000,0.0,858435.800000,2087281.100000,0.0,858437.000000,2087247.900000,0.0,858443.500000,2087214.700000,0.0,858453.400000,2087188.300000,0.0,858463.800000,2087161.900000,0.0,858482.800000,2087138.600000,0.0,858506.600000,2087134.900000,0.0,858543.000000,2087138.300000,0.0,858548.300000,2087128.500000,0.0,858545.200000,2087119.300000,0.0,858492.200000,2087075.500000,0.0,858472.000000,2087052.800000,0.0,858469.600000,2087040.400000,0.0,858474.300000,2087026.600000,0.0,858489.900000,2087004.700000,0.0,858500.800000,2086990.100000,0.0,858526.500000,2086942.600000,0.0,858536.600000,2086924.400000,0.0,858538.200000,2086904.600000,0.0,858533.500000,2086893.700000,0.0,858526.500000,2086887.900000,0.0,858522.700000,2086880.500000,0.0,858504.300000,2086854.300000,0.0,858507.800000,2086838.600000,0.0,858527.900000,2086806.000000,0.0,858502.400000,2086800.000000,0.0,858470.600000,2086793.400000,0.0,858456.300000,2086770.300000,0.0,858461.300000,2086732.600000,0.0,858490.400000,2086692.300000,0.0,858533.100000,2086623.800000,0.0,858571.600000,2086554.000000,0.0,858605.700000,2086533.200000,0.0,858627.000000,2086519.200000,0.0,858631.800000,2086505.300000,0.0,858629.000000,2086464.700000,0.0,858622.800000,2086434.400000,0.0,858631.500000,2086421.300000,0.0,858658.300000,2086408.300000,0.0,858668.800000,2086391.200000,0.0,858673.000000,2086368.800000,0.0,858665.200000,2086343.200000,0.0,858649.500000,2086321.500000,0.0,858636.200000,2086319.200000,0.0,858612.600000,2086336.500000,0.0,858602.400000,2086340.100000,0.0,858588.200000,2086337.500000,0.0,858581.900000,2086313.900000,0.0,858590.200000,2086270.700000,0.0,858607.700000,2086209.300000,0.0,858625.800000,2086185.000000,0.0,858655.200000,2086171.800000,0.0,858677.700000,2086149.100000,0.0,858675.600000,2086129.900000,0.0,858649.800000,2086111.600000,0.0,858650.100000,2086086.200000,0.0,858671.700000,2086071.800000,0.0,858695.800000,2086050.300000,0.0,858703.200000,2086029.800000,0.0,858709.800000,2086011.900000,0.0,858711.000000,2086010.300000,0.0,858731.500000,2085984.800000,0.0,858764.900000,2085957.100000,0.0,858800.000000,2085931.600000,0.0,858805.000000,2085900.000000,0.0,858812.400000,2085857.800000,0.0,858830.300000,2085821.300000,0.0,858842.800000,2085808.200000,0.0,858859.400000,2085800.400000,0.0,858873.900000,2085813.300000,0.0,858891.100000,2085822.400000,0.0,858922.300000,2085813.900000,0.0,858919.000000,2085791.800000,0.0,858929.300000,2085779.300000,0.0,858940.100000,2085745.000000,0.0,858943.400000,2085710.700000,0.0,858934.300000,2085693.000000,0.0,858911.700000,2085675.200000,0.0,858914.800000,2085659.600000,0.0,858928.600000,2085636.100000,0.0,858945.800000,2085616.800000,0.0,858953.000000,2085576.200000,0.0,858956.900000,2085537.900000,0.0,858962.900000,2085493.800000,0.0,858968.100000,2085485.500000,0.0,858989.000000,2085471.700000,0.0,859006.800000,2085455.300000,0.0,859044.400000,2085403.900000,0.0,859061.200000,2085376.600000,0.0,859072.500000,2085334.700000,0.0,859084.900000,2085301.500000,0.0,859103.800000,2085279.600000,0.0,859130.000000,2085270.000000,0.0,859143.500000,2085257.000000,0.0,859145.800000,2085167.200000,0.0,859139.600000,2085145.300000,0.0,859140.000000,2085140.000000,0.0,859141.900000,2085128.500000,0.0,859152.800000,2085110.300000,0.0,859157.600000,2085076.700000,0.0,859166.700000,2085067.200000,0.0,859174.200000,2085059.500000,0.0,859196.800000,2085037.900000,0.0,859229.300000,2085015.300000,0.0,859255.000000,2084984.700000,0.0,859272.900000,2084955.500000,0.0,859290.800000,2084920.400000,0.0,859312.600000,2084899.300000,0.0,859318.800000,2084876.600000,0.0,859313.400000,2084830.700000,0.0,859297.800000,2084792.700000,0.0,859279.100000,2084751.800000,0.0,859272.900000,2084733.600000,0.0,859281.500000,2084708.000000,0.0,859289.200000,2084668.800000,0.0,859295.000000,2084655.000000,0.0,859295.000000,2084630.000000,0.0,859295.000000,2084625.000000,0.0,859303.800000,2084601.600000,0.0,859310.000000,2084585.000000,0.0,859322.700000,2084563.500000,0.0,859348.000000,2084520.400000,0.0,859373.400000,2084452.700000,0.0,859385.000000,2084442.200000,0.0,859410.100000,2084438.700000,0.0,859453.200000,2084416.900000,0.0,859470.400000,2084400.200000,0.0,859520.600000,2084346.100000,0.0,859560.200000,2084293.200000,0.0,859616.400000,2084241.500000,0.0,859636.700000,2084235.000000,0.0,859676.400000,2084226.900000,0.0,859731.800000,2084227.100000,0.0,859753.000000,2084230.500000,0.0,859768.900000,2084215.500000,0.0,859788.500000,2084209.400000,0.0,859808.000000,2084194.100000,0.0,859820.400000,2084186.100000,0.0,859836.000000,2084185.300000,0.0,859852.300000,2084194.100000,0.0,859866.400000,2084197.000000,0.0,859883.500000,2084197.700000,0.0,859895.900000,2084207.200000,0.0,859912.600000,2084211.100000,0.0,859961.000000,2084198.100000,0.0,859288.808589,2083927.930883,0.0,860016.500000,2084194.300000,0.0)))

Merci

[philcero]

A première vue tu aurais 1620 coordonnées (540 points x 3 coordonnées) et tu dépasserais donc les 999 coordonnées.

La solution est de passer par du PL/SQL ou du Java. En général on donne l'exemple suivant :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
SQL> CREATE TABLE test_geom (id NUMBER, g1 mdsys.sdo_geometry);
 
Table created.
 
SQL>
SQL> DECLARE
  2    ord sdo_ordinate_array := sdo_ordinate_array();
  3  BEGIN
  4    FOR i IN 1 .. 5000 LOOP
  5        ord.EXTEND;
  6        ord(i) := i;
  7    END LOOP;
  8
  9    INSERT INTO test_geom VALUES (1, sdo_geometry(2001, null, null, sdo_elem_info_array(1, 1, 6), ord));
 13  END;
 14  /

[yanos_5]

Merci du conseil.

Si ce n'est pas trop abusé crois tu qu'une procédure identique existe pour un programme en C.

Le but final étant d'exécuter la requête depuis une application en C.

Merci

[philcero]

Personnellement je ne sais pas mais à mon avis cela ne doit pas poser de problème, suffit juste de transposer l'API et ça doit fonctionner...

Autre soluce pour ton cas, tu peux très bien alimenter une table temporaire avec tes coordonnées (id, ordre, x, y, z) et ensuite déclencher l'appel à une procédure PL/SQL qui va chercher pour un id donné toutes les coordonées avec un curseur, alimenter ton tableau et ensuite procéder à l'insertion.