[mapserver-users] Oracle Spatial layer has too many fields?
Josh Hevenor
jhevenor at rogers.com
Wed Dec 16 09:21:26 PST 2009
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
More information about the MapServer-users
mailing list