<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-15">
<META content="MSHTML 6.00.2900.3157" name=GENERATOR></HEAD>
<BODY style="MARGIN: 4px 4px 1px; FONT: 10pt Tahoma">
<DIV>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.</DIV>
<DIV> </DIV>
<DIV>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.</DIV>
<DIV> </DIV>
<DIV>Are there any negative consequences of making this change (except for greater memory usage) that I am not thinking about?</DIV>
<DIV> </DIV>
<DIV>Is there an easier way to allow columns with values > 256 characters to be displayed in an nquery template that I overlooked?</DIV>
<DIV> </DIV>
<DIV>I am using Oracle 10gR1 and Mapserver 4.10.2.</DIV>
<DIV> </DIV>
<DIV> </DIV></BODY></HTML>