Blank Image OracleSpatial

[Fernando Simon]

Hi,
    How did you imported the data to OracleSpatial? From shape to databse?
    Did you already tryed to execute the query that Mapserver used in
SQLPlus? Are you use some projection in your mapfile?
   Best regards.

------------------------------------------------------------------------
Fernando Simon
Mapserver and Oracle Spatial developer
G10 - Laboratorio de Computacao Aplicada - Brazil
http://www.univali.br/g10 - UNIVALI/CTTMAR
------------------------------------------------------------------------
   

José Ramón López wrote:
> 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 <http://172.21.128.99>]
> msOracleSpatialLayerOpen called with: SHAPE FROM RED_FERROCARRIL USING
> VERSION 9i\r
> [error] [client 172.21.128.99 <http://172.21.128.99>]
> msOracleSpatialLayerOpen. Shared connection not available. Creating one.\r
> [error] [client 172.21.128.99 <http://172.21.128.99>]
> msConnPoolRegister(ferrocarriles,sde/sde at SDE,01912370)\r
> [error] [client 172.21.128.99 <http://172.21.128.99>]
> msOracleSpatialLayerFreeItemInfo was called.\r
> [error] [client 172.21.128.99 <http://172.21.128.99>]
> msOracleSpatialLayerWhichShapes was called.\r
> [[error] [client 172.21.128.99 <http://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 <http://172.21.128.99>]
> msOracleSpatialLayerFreeItemInfo was called.\r
> [error] [client 172.21.128.99 <http://172.21.128.99>]
> msOracleSpatialLayerClose was called. Layer connection: sde/sde at SDE\r
> [error] [client 172.21.128.99 <http://172.21.128.99>]
> msOracleSpatialLayerClose. Cleaning layerinfo handlers.\r
> [error] [client 172.21.128.99 <http://172.21.128.99>]
> msOracleSpatialLayerClose. Cleaning Oracle handlers.\r
> [error] [client 172.21.128.99 <http://172.21.128.99>]
> msConnPoolRelease(ferrocarriles, sde/sde at SDE,01912370)\r
> [error] [client 172.21.128.99 <http://172.21.128.99>]
> msConnPoolClose(sde/sde at SDE,01912370)\r
> [error] [client 172.21.128.99 <http://172.21.128.99>] msDrawMap():
> Layer 2 (ferrocarriles), 0.218s\r
> [error] [client 172.21.128.99 <http://172.21.128.99>]
> msOracleSpatialLayerClose was called. Layer connection: sde/sde at SDE\r
>
> Thxs
> -- 
> José Ramón López
>