Blank Image OracleSpatial

[José Ramón López]

if I execute that, it does not give back anything , and the following
message;

SQL> SELECT rownum, SHAPE FROM RED_FERROCARRIL WHERE SDO_FILTER( SHAPE,
MDSYS.SDO_GEOMETRY(2003,
L,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(-
206.756757,-170,206.756757
) ),'querytype=window') = 'TRUE;

ninguna fila seleccionada
no selected row in english or something similar

I supposed that it was for that reason, but either like correcting it;

what can i do?

2006/11/23, umn-ms at hydrotec.de <umn-ms at hydrotec.de>:
>
>
> Hi
>
> * Does the logged SQL-Statement produce any output if you
>   execute it in SQL+?
> * Did you specify an SRID in Spatial-Metadata? Than you have to specify it
>    in the mapfile to.
>
> Benedikt
>
> UMN MapServer Users List <MAPSERVER-USERS at LISTS.UMN.EDU> schrieb am
> 23.11.2006 09:08:12:
>
> > Hi People!
> >
> > I have installed MS4W for Windows, with maplab, chamaleon, php 4.4.2 ...
> > I am with problems when I make a request on layer lodged in a oracle
> data base, because always shows a blank image.
> > 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.
> >
> > Im using oraclespatial method , not by OCI.
> >
> > In error.log file it appears:
> >
> > [error] [client 172.21.128.99] msOracleSpatialLayerOpen called with:
> SHAPE FROM RED_FERROCARRIL USING VERSION 9i\r
> > [error] [client 172.21.128.99] msOracleSpatialLayerOpen. Shared
> connection not available. Creating one.\r
> > [error] [client 172.21.128.99] msConnPoolRegister(ferrocarriles,
> sde/sde at SDE,01912370)\r
> > [error] [client 172.21.128.99] msOracleSpatialLayerFreeItemInfo was
> called.\r
> > [error] [client 172.21.128.99] msOracleSpatialLayerWhichShapes was
> called.\r
> > [[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
> > [error] [client 172.21.128.99] msOracleSpatialLayerFreeItemInfo was
> called.\r
> > [error] [client 172.21.128.99] msOracleSpatialLayerClose was called.
> Layer connection: sde/sde at SDE\r
> > [error] [client 172.21.128.99] msOracleSpatialLayerClose. Cleaning
> layerinfo handlers.\r
> > [error] [client 172.21.128.99] msOracleSpatialLayerClose. Cleaning
> Oracle handlers.\r
> > [error] [client 172.21.128.99] msConnPoolRelease(ferrocarriles,
> sde/sde at SDE,01912370)\r
> > [error] [client 172.21.128.99] msConnPoolClose(sde/sde at SDE,01912370)\r
> > [error] [client 172.21.128.99] msDrawMap(): Layer 2 (ferrocarriles),
> 0.218s\r
> > [error] [client 172.21.128.99] msOracleSpatialLayerClose was called.
> Layer connection: sde/sde at SDE\r
> >
> > Thxs
> > --
> > José Ramón López
>



-- 
José Ramón López
Tfno: 627 88 88 24
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20061123/5d2ed72e/attachment.html