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><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">Hi</font>
<br>
<br><font face="sans-serif" size="2">* Does the logged SQL-Statement produce
any output if you </font>
<br><font face="sans-serif" size="2"> execute it in SQL+?</font>
<br><font face="sans-serif" size="2">* Did you specify an SRID in Spatial-Metadata?
Than you have to specify it</font>
<br><font face="sans-serif" size="2"> in the mapfile to.</font>
<br>
<br><font face="sans-serif" size="2">Benedikt</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 09:08:12:</tt></font><div><span class="e" id="q_10f1495e277ef135_1"><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<br>
</tt></font></span></div>
</blockquote></div><br><br clear="all"><br>-- <br>José Ramón López<br>Tfno: 627 88 88 24