[Gvsig_english] new problems with an oracle layer

[Juan Lucas Dominguez Rubio]

Hello, Kornel. Thanks for doing that test.
 
Can you do exacty this, please?
 
- close gvSIG it it's running
- delete all the log files:
 
\home\<user>\gvSIG\*log*
 
- start gvSIG, create a view and add ONLY the table that caused the problem. The layer is visible in the view?
- open the attributes table. How many rows does it have? (it's written in the bottom margin of the attributes table)
 
- try to export the layer to SHP. When you see the error message, close gvSIG.
 
- send a ZIP file to the list containing the all the new log files: \home\<user>\gvSIG\*log*
 
- also, execute these three SQL sentences (replacing the values THE_OWNER and THE_TABLE_NAME with those of the table that caused the problem) and send the result:
 
(1) select COLUMN_NAME from ALL_SDO_GEOM_METADATA where  OWNER = 'THE_OWNER' and TABLE_NAME = 'THE_TABLE_NAME'
 
(2) desc THE_OWNER.THE_TABLE_NAME
 
(3) select count(*) FROM THE_OWNER.THE_TABLE_NAME
 
 
 
 

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: vie 18/06/2010 11:31
Para: gvsig_internacional at listserv.gva.es
Asunto: Re: [Gvsig_english] new problems with an oracle layer




hello,

i have executed:   "select * from PLAN.GRUEN_POLY t where  t.SHAPE.SDO_GTYPE
= NULL"

oracle return:   NULL
-------------------------------------------------------
The next test:
CREATE TABLE validate_results(sdo_rowid ROWID, status VARCHAR2(2000))
/
SDO_GEOM.VALIDATE_LAYER_WITH_CONTEXT('PLAN.GRUEN_POLY', 'SHAPE',
'validate_results');
/
SELECT * FROM validate_results ORDER BY status
/

At the moment a have a problem with the same user
1.) to create the table " validate_results" ["insufficient rights"   ]
and
2.) to read from "PLAN.GRUEN_POLY".  (the reading is for our default user
ok)   


( The other user can create and write, but can not read from
"PLAN.GRUEN_POLY"....)
 It must be changed.........

greetings from munich

-----
Kornel Kiss

Referat für Gesundheit und Umwelt
Anforderungsmanagement Fachanwendungen
Bayerstr. 28a
80335 München
--
View this message in context: http://osgeo-org.1803224.n2.nabble.com/new-problems-with-an-oracle-layer-tp5190806p5194638.html
Sent from the gvSIG international mailing list archive at Nabble.com.
_______________________________________________
Gvsig_internacional mailing list
Gvsig_internacional at listserv.gva.es
http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listserv.gva.es/pipermail/gvsig_internacional/attachments/20100618/bc489cff/attachment.htm