[mapserver-users] SQL Statement is truncuated at about 2000 bites

[Rotenhan von, Wernher]

Hello

When I use long SQL statements in my data statement (mapserver map file) they are cut at about 2000 bites and thus can not be executed.
On my SQLdeveloper those statements run perfect . I can use them form MSAccess via Paththrough

Database Oracle 11g
Driver:  Oracle Home
Mapserver : 6.0.1


A similar behavior was described at
Ticket #2694:     Buffer overflow in maporaclespatial with large sql data but that's long ago

As I can see in the maporaclespatial.c
the TABLE_NAME_SIZE is still limited to 2000

Why is this still so :-(   ... ?  (looked in the sources of 6.3)

...
#define TABLE_NAME_SIZE            2000
....

As I'm not a C++ freak  Can anybody make a new libmap.dll  with

#define TABLE_NAME_SIZE            4000


I would be very thankfull for any  hint / support
Wernher


The information contained in this email is confidential. It is intended solely for the addressee. Access to this email by anyone else is unauthorized. If you are not the intended recipient, any form of disclosure, reproduction, distribution or any action taken or refrained from in reliance on it, is prohibited and may be unlawful. Please notify the sender immediately.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20120910/c622e0f6/attachment.htm>