I think that I don`t have any value assigned to srid<br><br>SQL> select table_name,srid from user_sdo_geom_metadata where table_name='RED_FERROCARRIL';<br><br>TABLE_NAME SRID<br>-------------------------------- ----------
<br>RED_FERROCARRIL<br><br><br><div><span class="gmail_quote">2006/11/23, <a href="mailto:umn-ms@hydrotec.de">umn-ms@hydrotec.de</a> <<a href="mailto:umn-ms@hydrotec.de">umn-ms@hydrotec.de</a>>:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br><font face="sans-serif" size="2">What about the SRID? Is it set in Oracle-Metada?</font>
<br><font face="sans-serif" size="2">You may query it in SQL+ with</font>
<br>
<br><font face="sans-serif" size="2">select table_name,srid from user_sdo_geom_metadata
where table_name='RED_FERROCARRIL'</font>
<br><font face="sans-serif" size="2">(or </font>
<br><font face="sans-serif" size="2"> 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 <<a href="mailto:MAPSERVER-USERS@LISTS.UMN.EDU" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">MAPSERVER-USERS@LISTS.UMN.EDU</a>>
schrieb am 23.11.2006 12:50:34:</tt></font><div><span class="e" id="q_10f14c663dbdf491_1"><font size="2"><tt><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></span></div><div><span class="e" id="q_10f14c663dbdf491_3">
<br><font size="2"><tt>> 2006/11/23, <a href="mailto:umn-ms@hydrotec.de" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">umn-ms@hydrotec.de</a> <<a href="mailto:umn-ms@hydrotec.de" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
umn-ms@hydrotec.de</a>>:</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 <<a href="mailto:MAPSERVER-USERS@LISTS.UMN.EDU" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">MAPSERVER-USERS@LISTS.UMN.EDU</a>> 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 <a href="http://172.21.128.99" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">172.21.128.99</a>] msOracleSpatialLayerOpen called
with: SHAPE FROM RED_FERROCARRIL USING VERSION 9i\r<br>
> > [error] [client <a href="http://172.21.128.99" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">172.21.128.99</a>] msOracleSpatialLayerOpen. Shared
connection not available. Creating one.\r<br>
> > [error] [client <a href="http://172.21.128.99" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">172.21.128.99</a>] msConnPoolRegister(ferrocarriles,sde/sde@SDE,01912370)\r<br>
> > [error] [client <a href="http://172.21.128.99" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">172.21.128.99</a>] msOracleSpatialLayerFreeItemInfo
was called.\r<br>
> > [error] [client <a href="http://172.21.128.99" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">172.21.128.99</a>] msOracleSpatialLayerWhichShapes
was called.\r <br>
> > [[error] [client <a href="http://172.21.128.99" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">172.21.128.99</a>] 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 <a href="http://172.21.128.99" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">172.21.128.99</a>] msOracleSpatialLayerFreeItemInfo
was called.\r <br>
> > [error] [client <a href="http://172.21.128.99" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">172.21.128.99</a>] msOracleSpatialLayerClose was
called. Layer connection: sde/sde@SDE\r<br>
> > [error] [client <a href="http://172.21.128.99" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">172.21.128.99</a>] msOracleSpatialLayerClose. Cleaning
layerinfo handlers.\r <br>
> > [error] [client <a href="http://172.21.128.99" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">172.21.128.99</a>] msOracleSpatialLayerClose. Cleaning
Oracle handlers.\r<br>
> > [error] [client <a href="http://172.21.128.99" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">172.21.128.99</a>] msConnPoolRelease(ferrocarriles,
sde/sde@SDE,01912370)\r<br>
> > [error] [client <a href="http://172.21.128.99" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">172.21.128.99</a>] msConnPoolClose(sde/sde@SDE,01912370)\r<br>
> > [error] [client <a href="http://172.21.128.99" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">172.21.128.99</a>] msDrawMap(): Layer 2 (ferrocarriles),
0.218s\r<br>
> > [error] [client <a href="http://172.21.128.99" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">172.21.128.99</a>] 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>
</span></div></blockquote></div><br><br clear="all"><br>-- <br>José Ramón López<br>Tfno: 627 88 88 24