<br><font size=2 face="sans-serif">What about the SRID? Is it set in Oracle-Metada?</font>
<br><font size=2 face="sans-serif">You may query it in SQL+ with</font>
<br>
<br><font size=2 face="sans-serif">select table_name,srid from user_sdo_geom_metadata
where table_name='RED_FERROCARRIL'</font>
<br><font size=2 face="sans-serif">(or </font>
<br><font size=2 face="sans-serif"> select "OWNER", table_name,
srid from user_sdo_geom_metadata where table_name='RED_FERROCARRIL')</font>
<br>
<br><font size=2><tt>UMN MapServer Users List <MAPSERVER-USERS@LISTS.UMN.EDU>
schrieb am 23.11.2006 12:50:34:<br>
<br>
> if I execute that, it does not give back anything , and the following
message;<br>
> <br>
> SQL> SELECT rownum, SHAPE FROM RED_FERROCARRIL WHERE SDO_FILTER(
SHAPE, MDSYS.SDO_GEOMETRY(2003,<br>
> L,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3), MDSYS.SDO_ORDINATE_ARRAY(-206.756757,-170,206.756757<br>
> ) ),'querytype=window') = 'TRUE;<br>
> <br>
> ninguna fila seleccionada <br>
> no selected row in english or something similar<br>
> <br>
> I supposed that it was for that reason, but either like correcting
it; <br>
> <br>
> what can i do?<br>
</tt></font>
<br><font size=2><tt>> 2006/11/23, umn-ms@hydrotec.de <umn-ms@hydrotec.de>:</tt></font>
<br><font size=2><tt>> <br>
> Hi <br>
> <br>
> * Does the logged SQL-Statement produce any output if you <br>
> execute it in SQL+? <br>
> * Did you specify an SRID in Spatial-Metadata? Than you have to specify
it <br>
> in the mapfile to. <br>
> <br>
> Benedikt <br>
> <br>
> UMN MapServer Users List <MAPSERVER-USERS@LISTS.UMN.EDU> schrieb
am 23.11.2006 09:08:12:</tt></font>
<br><font size=2><tt>> <br>
> <br>
> > Hi People!<br>
> > <br>
> > I have installed MS4W for Windows, with maplab, chamaleon, php
4.4.2 ...<br>
> > I am with problems when I make a request on layer lodged in a
oracle data base, because always shows a blank image.<br>
> > Im using Oracle 9i and Spatial. The dlls are in dlls their corresponding
directories. If I make a request on a layer lodged in a data file, this
is is correctly.<br>
> > <br>
> > Im using oraclespatial method , not by OCI.<br>
> > <br>
> > In error.log file it appears:<br>
> > <br>
> > [error] [client 172.21.128.99] msOracleSpatialLayerOpen called
with: SHAPE FROM RED_FERROCARRIL USING VERSION 9i\r<br>
> > [error] [client 172.21.128.99] msOracleSpatialLayerOpen. Shared
connection not available. Creating one.\r<br>
> > [error] [client 172.21.128.99] msConnPoolRegister(ferrocarriles,sde/sde@SDE,01912370)\r<br>
> > [error] [client 172.21.128.99] msOracleSpatialLayerFreeItemInfo
was called.\r<br>
> > [error] [client 172.21.128.99] msOracleSpatialLayerWhichShapes
was called.\r <br>
> > [[error] [client 172.21.128.99] msOracleSpatialLayerWhichShapes.
Using this Sql to retrieve the data: SELECT rownum, SHAPE FROM RED_FERROCARRIL
WHERE SDO_FILTER( SHAPE, MDSYS.SDO_GEOMETRY (2003, NULL, NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(-206.756757,-170,206.756757,170)
),'querytype=window') = 'TRUE'\r<br>
> > [error] [client 172.21.128.99] msOracleSpatialLayerFreeItemInfo
was called.\r <br>
> > [error] [client 172.21.128.99] msOracleSpatialLayerClose was
called. Layer connection: sde/sde@SDE\r<br>
> > [error] [client 172.21.128.99] msOracleSpatialLayerClose. Cleaning
layerinfo handlers.\r <br>
> > [error] [client 172.21.128.99] msOracleSpatialLayerClose. Cleaning
Oracle handlers.\r<br>
> > [error] [client 172.21.128.99] msConnPoolRelease(ferrocarriles,
sde/sde@SDE,01912370)\r<br>
> > [error] [client 172.21.128.99] msConnPoolClose(sde/sde@SDE,01912370)\r<br>
> > [error] [client 172.21.128.99] msDrawMap(): Layer 2 (ferrocarriles),
0.218s\r<br>
> > [error] [client 172.21.128.99] msOracleSpatialLayerClose was
called. Layer connection: sde/sde@SDE\r<br>
> > <br>
> > Thxs<br>
> > -- <br>
> > José Ramón López</tt></font>
<br><font size=2><tt>> <br>
> <br>
> <br>
> -- <br>
> José Ramón López<br>
> Tfno: 627 88 88 24 </tt></font>