[Gvsig_english] new problems with an oracle layer

[K.Kiss]

select ROWID, c."OBJECTID", c."GE_CODE", c."TYP2", c."TYP3",
c."GRUEN_GRUE", c."FLAECHE_HA", c."SE_ANNO_CAD_DATA", c."OGR_FID", c.SHAPE
from PLAN.GRUEN_POLY c where (sdo_relate(SHAPE, mdsys.sdo_geometry(2003,
31468, null, mdsys.sdo_elem_info_array(1, 1003, 3),
mdsys.sdo_ordinate_array(4400000, 5300000,
4500000,5500000)), 'mask=anyinteract querytype=window') =
'TRUE')

hello,

i changed the coordinates and the the SQL-statement run  in "toad.exe" 
6242  total rows found.......here´s no problem

here 1 sample:
OBJECTID;GE_CODE;TYP2;TYP3;GRUEN_GRUE;FLAECHE_HA;SE_ANNO_CAD_DATA;OGR_FID;SHAPE
6105;16;1;1;39576,493104;3,957649;;6058;(3007; 31468; ; (1; 1003; 1; 97;
2003; 1; 121; 2003; 1; 145; 2003; 1; 178; 2003; 1; ; ; ; ; ; ; ; ; ; ; ; ; ;
; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ;
; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; );
(4478045,89999182; 5331866,63997669; 0; 4478048,84899133; 5331867,02997663;
0; 4478042,91949231; 5331872,29397576; 0; 4478021,76999579;
5331869,46997622; 0; 4477971,68000404; 5331866,68997668; 0;
4477900,11401582; 5331866,62547669; 0; 4477716,85004599; 5331866,45997672;
0; 4477723,00004498; 5331860,91997763; 0; 4477723,55004489;
5331860,44997771; 0; 4477724,45004474; 5331859,63997784; 0;
4477727,81004418; 5331856,61997834; 0; 4477735,65004289; 5331849,5699795; 0;
4477743,4800416; 5331842,52998066; 0; 4477759,14003903; 5331828,42998298; 0;
4477774,78003645; 5331814,3699853; 0; 4477790,45003387; 5331800,26998762; 0;
4477810,76003053; 5331781,98999063; 0; 4477816,73002955; 5331776,61999151;
0; 4477836,00002637; 5331759,27999436; 0; 4477851,22002387;
5331745,58999662; 0; 4477866,47002136; 5331731,84999888; 0;
4477881,72001885; 5331718,14000114; 0; 4477912,9700137; 5331690,02000577; 0;
4477928,61001113; 5331675,95000808; 0; 4477955,61000668; 5331651,65001208;
0; 4477961,64000569; 5331646,22001298; 0; 4477973,77000369;
5331635,31001477; 0; 4477991,24620081; 5331619,59201736; 0;
4478167,40017181; 5331758,23319454; 0; 4478122,65997918; 5331797,16998813;
0; 4478118,77997982; 5331800,54998757; 0; 4478045,89999182;
5331866,63997669; 0; 4478070,41098778; 5331834,65838196; 0;
4478087,06318504)) 

-----
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-tp5190806p5203636.html
Sent from the gvSIG international mailing list archive at Nabble.com.