[mapserver-users] Oracle Spatial layer has too many fields?

[Alan Boudreault]

I experienced the same problem yesterday.... the column name was "LONG", which 
is an ORACLE reserved word too >:| . So for the record, never use "LONG" 
(which meant LONGITUDE" in my case) for a column name... even quoted... 
otherwise you'll experienced problems soon or later.

Alan 

On December 16, 2009 01:35:44 pm Josh Hevenor wrote:
> Thanks Alan,
> I found the query in the log file and ran it through SqlDeveloper to see
> the full query was valid.  Nope!  One of the new columns shared a name
> with a reserved word.
> 
> For now I'll rename the column to play nice. But, if MapServer quoted
> the field name list it built then this case should be covered...
> 
>     select "f1", "f1", "GROUP" FROM (select * from someTable)...
> 
> Sorry to bug everyone with this,
> 
> Josh
> 
> Alan Boudreault wrote:
> > Hi Josh,
> >
> > May you add the directive "debug 5" at the map and layer levels in
> > your mapfile to see what sql query is executed. You may have to add
> > the directive "CONFIG "MS_ERRORFILE" "/tmp/mapserver.log"" to redirect
> > the logs in a file.
> >
> > Alan
> >
> > On December 16, 2009 12:21:26 pm Josh Hevenor wrote:
> > > Error:
> > >
> > >
> > >
> > > I was adding new fields to an Oracle Spatial layer, now having 61
> > > fields
> > >
> > > defined with
> > >
> > >
> > >
> > > geom from (select * from spatialTable) using ...
> > >
> > >
> > >
> > > Process
> > >
> > >
> > >
> > > $layer->qryByRect
> > >
> > > $layer->open
> > >
> > > For()
> > >
> > > $res=$layer->getResult
> > >
> > > $shp=$res->getShape // Fails, line 637
> > >
> > >
> > >
> > > Error
> > >
> > > Fatal error: [MapServer Error]: msOracleSpatialLayerGetShape():
> > >
> > > Error: ORA-00936: missing expression
> > >
> > > Query statement: SELECT field1, field2, field3,..., GEOM FROM
> > >
> > > (select * from spatialTable in <b>C:\MSMap\genQuery.php</b> on line
> > > 637;
> > >
> > >
> > >
> > > I feel this query is getting cut off.
> > >
> > > If I redefine the layer using some specific subset of fields my query
> > >
> > > works again
> > >
> > >
> > >
> > > GEOM from (select field1, field2, ..., fieldX, geom from
> > >
> > > spatialTable)... X < 61
> > >
> > >
> > >
> > > The code is old and has run solidly for a long time. The fields are
> > >
> > > new. Is there a limit on the number of fields/query string length in
> > >
> > > PHP mapscript? Any thoughts?
> > >
> > >
> > >
> > > Thanks in advance,
> > >
> > >
> > >
> > > Josh
> > >
> > >
> > >
> > >
> > >
> > > _______________________________________________
> > >
> > > mapserver-users mailing list
> > >
> > > mapserver-users at lists.osgeo.org
> > >
> > > http://lists.osgeo.org/mailman/listinfo/mapserver-users
> >
> > Alan Boudreault
> >
> > Mapgears
> >
> > http://www.mapgears.com
> >
> > ------------------------------------------------------------------------
> >
> >
> > No virus found in this incoming message.
> > Checked by AVG - www.avg.com
> > Version: 8.5.427 / Virus Database: 270.14.110/2568 - Release Date:
> > 12/16/09 08:02:00
> 

-- 
Alan Boudreault
Mapgears
http://www.mapgears.com