Oracle Spatial Filter problem

[Zhonghai Wang]

Hi Simon,

how is everything? thanks for your hints.

as you said, I set the Filter again like this:

DATA "GEOLOC FROM E112_CELLS_GEO USING FILTER"
FILTER "cell='BAMK5D'"

with the cell='BAMK5D' condition in the SQLPlus 12 elements will be
selected, but with mapserverit returns still some error messages:

msOracleSpatialLayerWhichShapes(): OracleSpatial error. Error: ORA-29902:
error in executing ODCIIndexStart() routine
ORA-13208: internal error  while evaluating [window SRID does not match
layer SRID] operator
ORA-06512: at "MDSYS.SDO_INDEX_METHOD_9I", line 259
ORA-06512: at line 1
 . Query statement: SELECT rownum, GEOLOC FROM E112_CELLS_GEO WHERE
cell='BAMK5D' AND SDO_FILTER( GEOLOC, MDSYS.SDO_GEOMETRY(2003, NULL, NULL,
MDSYS.SDO_ELEM_INF
O_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(5.95587,45.11214,10.49203,
48.51426) )
,'querytype=window') = 'TRUE' .
Check your data statement.

It seems that I should specify certain SRID code, but in this case the SRID
code is not necessary.

BTW: the SRID is 8307

thanks

zhonghai


On 6/26/06, Fernando Simon <fsimon at univali.br> wrote:
>
> Hi,
>    Just remove the "WHERE" from FILTER parameter. Like: FILTER
> "MI_PRINX =100"
>    Best regards.
>
> Fernando Simon
>
> Zhonghai Wang wrote:
> > Hi there,
> >
> > I am trying to render the map with oracle spatial database, and facing
> > problems with the FILTER expression.
> >
> > at first I define the oracle spatial connection like:
> >
> > CONNECTIONTYPE ORACLESPATIAL
> > CONNECTION "E110/E110 at PMCGIS2.WORLD <mailto:E110/E110 at PMCGIS2.WORLD>"
> > DATA "GEOLOC FROM E112_CELLS_GEO USING UNIQUE MI_PRINX SRID 8307"
> >
> > and this one works fine, therefore I am sure that the mapfile
> > definition is ok, and then I change the data connection to :
> >
> > CONNECTIONTYPE ORACLESPATIAL
> > CONNECTION "E110/E110 at PMCGIS2.WORLD <mailto:E110/E110 at PMCGIS2.WORLD>"
> > DATA "GEOLOC FROM E112_CELLS_GEO USING FILTER"
> > FILTER "WHERE  MI_PRINX =100"
> >
> > to use the FILTER function for a specific selection, but this
> > definition gives aan error instead of the map image:
> >
> > ERROR:
> > msOracleSpatialLayerWhichShapes(): OracleSpatial error. Error:
> > ORA-00936: missing expression .
> > Query statement: SELECT rownum, GEOLOC FROM E112_CELLS_GEO WHERE WHERE
> > MI_PRI
> > NX=100 AND SDO_FILTER( GEOLOC, MDSYS.SDO_GEOMETRY(2003, NULL,
> > NULL,MDSYS.SDO_ELE
> > M_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(5.95587
> > ,45.11214,10.49203,48.514
> > 26) ),'querytype=window') = 'TRUE' .
> > Check your data statement.
> >
> > I can not figure out where the problem is. the MI_PRINX is the unique
> > id of the table, if I make this query in the SQLPlus, the data will be
> > returned, which means the where condition in the SQL is no problem.
> >
> > any ideas for this?
> >
> > kind regards
> >
> > zhonghai
> >
> >
> >
> >
> >
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20060626/616bc939/attachment.html