Bonjour,

j'essaie d'importer des données spatial dans une table, mais rien n'y fait.
Je ne comprend pas, c'est toujours la même procédure que j'utilise pourtant !

Voila une partie du script (a terme presque 385000 objets) :
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
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
LOAD DATA INFILE *
TRUNCATE
CONTINUEIF NEXT(1:1)='#'
INTO TABLE GEOMETRY.SHAPE_GEOMETRY
FIELDS TERMINATED BY '|'
TRAILING NULLCOLS(
  SHAPE_GEOM_ID FLOAT,
  SHAPE_GEOM_GUID CHAR,
  EVENT_ID FLOAT,
  EVENT_GUID CHAR,
  FEATURE_ID CHAR,
  DESCRIPTION CHAR,
  CREATE_DATE DATE "YYYY-MM-DD",
  GEOMETRY COLUMN OBJECT (
    SDO_GTYPE INTEGER,
    SDO_SRID INTEGER,
    SDO_ELEM_INFO VARRAY TERMINATED BY '|/'
    (elements FLOAT EXTERNAL),
    SDO_ORDINATES VARRAY TERMINATED BY '|/'
    (ordinates FLOAT EXTERNAL)
  )
)
BEGINDATA
 135468|CC21__PPA000258547-0001|94246|CC21__PPA000258547-0001|POPULATED_AREA|Cimetière|2009-02-08|
#3002|41014|1|2|1|/
#393039.541409|167172.572787|0.00|393063.301155|167165.339443|0.00|393070.188037|167135.717178|0.00|393066.744596|167127.450499|0.00|393052.626486|167139.161627|0.00|393030.932805|167145.361636|0.00|393039.541409|167172.572787|0.00|/
 135469|CC21__PPA000258547-0002|94247|CC21__PPA000258547-0002|POPULATED_AREA|Tennis|2009-02-08|
#3002|41014|1|2|1|/
#393021.314684|167208.165779|0.00|393013.151592|167174.142885|0.00|393030.534225|167169.972281|0.00|393038.697317|167203.995174|0.00|393021.314684|167208.165779|0.00|/
 135470|CC21__STR000258547-0003|94248|CC21__STR000258547-0003|STRUCTURE|TIGF : CENTRE DE STOCKAGE SOUTERRAIN DE GAZ|2009-02-08|
#3002|41014|1|2|1|/
#394336.761866|167902.985111|0.00|394392.88474|167855.323364|0.00|394402.137198|167862.319928|0.00|394461.260661|167860.508616|0.00|394484.186085|167915.451758|0.00|394528.227032|167898.546176|0.00|394603.639612|167871.37649|0.00|394607.259416|167861.716157|0.00|394565.631672|167836.961555|0.00|394545.722751|167802.546619|0.00|394558.392064|167778.395787|0.00|394557.788763|167757.26381|0.00|394554.77226|167749.414789|0.00|394465.483765|167739.754457|0.00|394421.264484|167759.230068|0.00|394427.888407|167683.682662|0.00|394440.14762|167644.602122|0.00|394439.674625|167625.194116|0.00|394414.132855|167512.533011|0.00|394262.36667|167464.866068|0.00|394200.510328|167438.870774|0.00|394135.236917|167406.681887|0.00|394112.060126|167414.255743|0.00|394087.464348|167418.989403|0.00|394074.220467|167427.036625|0.00|394035.014373|167545.190434|0.00|394040.690322|167575.959224|0.00|394056.299181|167600.100889|0.00|394052.988211|167654.064612|0.00|394044.947284|167663.058566|0.00|394028.865429|167654.537978|0.00|394002.462947|167637.869713|0.00|393991.111049|167641.656641|0.00|393966.042275|167655.857621|0.00|393949.014429|167666.271673|0.00|393945.230463|167674.792261|0.00|393975.975185|167715.819956|0.00|394006.719908|167736.648059|0.00|394019.490793|167755.582699|0.00|394020.903|167775.21|0.00|394048.189|167856.179|0.00|394035.681|167893.053|0.00|394040.58|167903.85|0.00|394076.275|167916.377|0.00|394101.476|167902.797|0.00|394112.265|167871.553|0.00|394107.103|167847.483|0.00|394111.785235|167834.646556|0.00|394165.108|167890.432|0.00|394195.809136|167927.600142|0.00|394257.298582|167932.807168|0.00|394272.907441|167900.618281|0.00|394336.761866|167902.985111|0.00|/
 135471|CC21__STR000258547-0004|94248|CC21__STR000258547-0003|STRUCTURE|NULL|2009-02-08|

Tout ce que j'ai comme réponse :
Record 1: Rejected - Error on table GEOMETRY.SHAPE_GEOMETRY, column GEOMETRY.SDO_ELEM_INFO.ELEMENTS.
error converting data
ORA-01722: invalid number
Je ne vois pas ou est le problème....