[Gvsig_english] new problems with an oracle layer

K.Kiss kornel.kiss at muenchen.de
Fri Jun 18 11:31:05 CEST 2010


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.


More information about the Gvsig_internacional mailing list