Geodetic problems in maporaclespatial

[fsimon@…]

Mike Smith from US Army Engineer Research & Development Center reported when
the data stored in database contains geodetic SRID the FILTER, RELATE and
GEOMRELATE funtions need to change how it apply the bbox.
   Mike suggest to use the VIEW_TRANSFORM function whnre the SRID is between
8192 and 8316. 
   Part of the Mike's code:
   .....
        if ((srid>=8192)&&(srid<=8316))
	{
		sprintf( query_str + strlen(query_str),
			"SDO_FILTER( %s.%s, SDO_CS.VIEWPORT_TRANSFORM(MDSYS.SDO_GEOMETRY("
			"2003, 0, NULL,"
			"MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),"
			"MDSYS.SDO_ORDINATE_ARRAY(%.9g,%.9g,%.9g,%.9g) ), %s),"
			"'querytype=window') = 'TRUE'",
			table_name, geom_column_name, rect.minx, rect.miny, rect.maxx, rect.maxy, srid );
	}
    ......

    Thanks.

[fsimon@…]

   This problem really occour when exist geodetic data. This problem occour only
in Oracle 8i and 9i, the 10g version can work with geodetic data without problem.
   To fix this problem will be necessary create "VERSION" token for layer data
string. This is necessary because the 8i version don't have any function to work
with geodetic data, in the Oracle Spatial documentation for 8i version they
related this problem but don't show any way how to solve this problem. The
solution appear only in 9i version using the VIEWPORT_TRANSFORM function.
   Now the user can define the version that will use. The user can define in the
end of layer data string 3 tokens:
   "... VERSION 8i"
   "... VERSION 9i"
   "... VERSION 10g"
   If the user define the 9i version and geodetic data the code will use
VIEWPORT function. If user define 8i version and geodetic data the code can't
call VIEWPORT function because don't exist any way to find the best bbox for
geodetic data in Oracle 8i database.
   The use can use none of this token in layer data string. If the user don't
define any of this tokens and geodetic data the bbox can't be accurate.
   Thanks

[fsimon@…]

Fixed in CVS version of maporaclespatial.c in Mapserver 4.5.
Thanks.