<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Andreas Albarello wrote:
<blockquote cite="mid46E56D29.7020405@territoriumonline.com" type="cite">Damien
Corpataux wrote:
<br>
<blockquote type="cite">Hello List,
<br>
<br>
I ran into memory corrption with a long sql query in the DATA object,
for an Oracle LAYER. It is obviously due to Mapserver memory allocation
mechanism. The corruption occurs when the DATA is longer than ca. 2037
characters.
<br>
<br>
Do you know if Mapserver has a way of modifying the possible allocated
memory limit? In header files? By applying a patch?
<br>
<br>
Any idea is welcome!
<br>
</blockquote>
<br>
Damien,
<br>
<br>
replace all occurrences of table_name[2000] with table_name[n] (where n
is the maximum data statement length you would like to have) in
maporaclespatial.c. That should fix it.
<br>
<br>
Best regards,
<br>
</blockquote>
<br>
Hello Andreas,<br>
<br>
Thanks for the Tip! It works! I suppose that the default limit (2000)
is a good compromise for memory_usage/use_cases_coverage, so let's
patch the source when a project needs it (and perhaps buy some more RAM
for the server :-))<br>
<br>
Thanks a lot for the precious help, regards,<br>
Damien<br>
<br>
<br>
<div class="moz-signature">-- <br>
<style>
<!--
.signature {
font-family:verdana,helvetica,sans-serif;
font-size:0.8em;
line-height: 1.25em;
color: #9999BB;
width: 27em;
}
.signature div {
padding: 0.22em;
margin-bottom: 0.5em;
margin-top: 0.5em;
border-bottom: 1px dotted lightgray;
background-color: #FCFCFF;
}
.signature .attention {
background-color: #FFFAFA;
color: #FFBBBB;
font-size: 0.8em;
font-weight: bold;
}
.header {
}
-->
</style>
<div class="signature">
<div> <span style="font-weight: bold;">Camptocamp SA</span><br>
Damien Corpataux<br>
PSE A<br>
CH-1015 Lausanne<br>
</div>
<div> +41 21 619 10 22 <span class="header">(Direct)</span><br>
+41 21 619 10 10 <span class="header">(Centrale)</span><br>
+41 21 619 10 00 <span class="header">(Fax)</span><br>
</div>
<div style="color: rgb(102, 204, 102);"> <span
style="position: relative; top: -3px; font-family: Webdings; font-size: 24pt;">P</span>
<span style="">Please consider the environment <br>
Do you really need to print this email?</span>
</div>
</div>
</div>
</body>
</html>