[Gvsig_english] Transfering Data to oracle Spatial

Rolf Annecke Rolf.Annecke at muenchen.de
Fri Apr 23 09:31:16 CEST 2010


Hi List,
my name is Rolf Annecke and I am new in your list.
I am the 3rd user of gvSIG in the Department for Health and Environment 
in the City of Munich.
My question deals with the import of datas in Oracle Spatial.
I am connected to an WFS-Server.  The field length of one item is more 
than 100; it is  about 300. I can see the whole content in the table.
Transfering this data to oracle spatial I get a mistake with the 
following report:
   java.sql.SQLException: ORA-12899: Wert zu groß für Spalte 
"T_RGU"."TEST"."listentext" (aktuell: 114, maximal: 100)
It seems, that there is a limitation to 100 characters.
The same mistake occured by transfering the adequate csv-Datas.

Is this limitation to 100 characters caused by
    a) gvSIG or is this caused by
    b) the database of oracle spatial?

If a), do you know a way transfering data to oracle with more than 100 
characters by gvSIG?
Thank you for your answers.
Best
Rolf Annecke

-- 
_________________________________________________
Rolf Annecke
Referat für Gesundheit und Umwelt
Abteilung Umweltschutz
Gesundheits- und Umweltberichterstattung (GUBE)
RGU-UW112
Bayerstr. 28a
80335 München

Telefon: +49 - 89 - 233 - 4 77 15 
Telefax: +49 - 89 - 233 - 4 77 05 
Mailbüro: gube.rgu at muenchen.de

Elektronische Kommunikation mit der Landeshauptstadt München:
http://www.muenchen.de/ekomm



More information about the Gvsig_internacional mailing list