SDO_VERSION Returns Null Instead of Version Number Leading To Problems Using Mapinfo (Doc ID 944854.1)

Last updated on MAY 27, 2010

Applies to:

Oracle Spatial - Version: 10.2.0.1 to 11.2.0.1.0 - Release: 10.2 to
Information in this document applies to any platform.

Symptoms

SDO_VERSION returns NULL in customer database which was a showstopper. The reason is that their GIS tool (Mapinfo) checks SDO_VERSION to find out if spatial queries are available, and if not starts using full table scan queries (= does not submit any spatial queries).


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms