[mapserver-users] Oracle Spatial error info gone in 4.0?

[Bart van den Eijnden]

Hi,

what has happened to the Oracle Spatial error messages in 4.0 beta?

In old versions when you supplied an invalid column in the DATA statement, 
you got an exception in your browser containing the Oracle SQL statement in 
the ORA error, which is quite useful. Now I only get the error message:

msDrawMap(): Image handling error. Failed to draw layer named 'kwadranten'

In the "old" documentation there is also something about this (see 
http://mapserver.gis.umn.edu/doc36/mapfile-reference.html):

For Oracle, use "shape FROM table" or "shape FROM (SELECT statement)" or 
even more complex Oracle compliant queries! Note that there are important 
performance impacts when using spatial subqueries however. Try using 
MapServer's FILTER whenever possible instead. You can also see the SQL 
submitted by forcing an error, for instance by submitting a DATA parameter 
you know won't work, using for example a bad column name.

Best regards,
Bart