[Gvsig_english] Oracle spatial, field length different after exporting to shapefile

[Juan Lucas Dominguez Rubio]

Hello, Kornel:
 
I thought you were talking about Oracle Spatial, but now I see your table is an alphanumeric one. I do not know in detail how the gvSIG alphanumeric Oracle driver works, sorry.
 
However, I have succesfully exported the table to SHP after creating another view which leaves out the OBJEKT_ID field:
 
CREATE VIEW TEST_AUS_VIEW_V ("NAME", "STRASSEHAUSNR", "PLZ", "ORT", "ANNOTATIONO", "Y", "X") AS SELECT "NAME", STRASSEHAUSNR, PLZ, ORT, ANNOTATIONO, Y, X FROM TEST_AUS_VIEW;
 
Then repeat the same process you did, but using TEST_AUS_VIEW_V as the table name. I have obtained a 1.5-megabyte DBF file. The string fields are cropped to 254 characters (possibly a DBF limitation)
 
If your database is an Oracle Spatial or Locator database, there might be other ways to do this without renouncing to the OBJEKT_ID field, but I don't know if the 254-character limit in DBF files can be avoided. Is it an Oracle Spatial DB or a traditional alphanumeric Oracle DB?
 
***
 
Apart from that: the parameters for the public Oracle Spatial DB have changed, now the port is 80, so maybe you will be able to access it too from your restricted network:
 
URL: lucasdom.homelinux.org
Port: 80
DB name: xe
User: gvsig
Password: gvsig
 
 
 
Regards,
 
Juan Lucas Domínguez Rubio
---
Prodevelop SL, Valencia (España)
Tlf.: 96.351.06.12 -- Fax: 96.351.09.68
http://www.prodevelop.es <http://www.prodevelop.es/> 
---

________________________________

De: gvsig_internacional-bounces at listserv.gva.es en nombre de K.Kiss
Enviado el: mar 14/12/2010 17:00
Para: gvsig_internacional at listserv.gva.es
Asunto: Re: [Gvsig_english] Oracle spatial, field length different after exporting to shapefile




Hello,

I have a similar problem. Briefly described:
A Oracle View has originally a field of the type Varchar2 with 4000 byte.

If I try into gvSIG (table is loaded and with X/Y - coordinates provide) the
table as Shape to export.
The presentation was ok.
It comes to export errors. 0bytes written