OracleSpatial driver - VARCHAR2(4000)

[Jim Klassen]

I am trying to access a spatial table with a VARCHAR2(4000) column from
one of our Oracle spatial databases. Things work great for mode=map, but
for mode=nquery I am getting an error returned by mapserver in
msOracleSpatialLayerGetShape() that Oracle had to truncate one of the
fields.
 
I noticed that in maporaclespatial.c TEXT_SIZE is defined to be 256 and
this seems to be used to determine the size of the pointers and the max
allowed column length passed to oracle in OCIDefineByPos(...) on line
2155 in msOracleSpatialLayerGetShape(). So, I changed TEXT_SIZE to 4000,
and recompiled Mapserver and now I get the expected result of the entire
value of the column being substituted into the nquery template.
 
Are there any negative consequences of making this change (except for
greater memory usage) that I am not thinking about?
 
Is there an easier way to allow columns with values > 256 characters to
be displayed in an nquery template that I overlooked?
 
I am using Oracle 10gR1 and Mapserver 4.10.2.
 
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-dev/attachments/20070822/c5a68e47/attachment.html