<br>Hello list!<br><br>I'm configuring a WFS service with ms4w v1.6 version. I'm having some problems with Oracle.<br>The featureclasses in my geodatabase all have a blob data typed field. I've read that MapServer doesn't support this format. So, I have to make a query, with all fields except blob field, like this:
<br><br>DATA "SHAPE FROM (SELECT OBJECTID, SHAPE, COD_ENT, TIPO_LIN, TIPO FROM RED_FERROCARRIL) USING UNIQUE OBJECTID VERSION 9i"<br><br>After running this, I have to wait for several minutes, but nothing is returned. But, if I make this another query, specifying an OBJECTID field, the data are showed by the client:
<br><br>DATA "SHAPE FROM (SELECT OBJECTID, SHAPE, COD_ENT, TIPO_LIN, TIPO FROM RED_FERROCARRIL WHERE OBJECTID=50) USING UNIQUE OBJECTID VERSION 9i"<br clear="all"><span style="font-style: italic;"></span><br>Notice that all this query are made with Oracle Spatial ConnectionType.
<br><br>If instead doing this, I make this query using the OCI driver:<br><br>CONNECTIONTYPE OGR<br>CONNECTION "OCI:user/pass@SDE"<br>DATA "RED_FERROCARRIL"<br><br>I can see all the features stored in the featureclass, but the client spends a lot of time to show it. Could anybody tell me, why does it happen?
<br><br>I've been reading some articles about the filter with Oracle Spatial, but I still don't know how to use it. <br>Could anybody of you help me? Is this problem related with the filters?<br><br>Thank you very much.
<br>-- <br>José Ramón López<br>Tfno: 627 88 88 24