Antwort: Re: [UMN_MAPSERVER-USERS] Blank Image OracleSpatial

[Benedikt Rothe]

What about the SRID? Is it set in Oracle-Metada?
You may query it in SQL+ with

select table_name,srid from user_sdo_geom_metadata where 
table_name='RED_FERROCARRIL'
(or 
 select "OWNER", table_name, srid from user_sdo_geom_metadata where 
table_name='RED_FERROCARRIL')

UMN MapServer Users List <MAPSERVER-USERS at LISTS.UMN.EDU> schrieb am 
23.11.2006 12:50:34:

> 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/e1832c66/attachment.htm>