SpatialDB Advisor

New version of PL/SQL packages released

I have not reported on the numerous released of my PL/SQL packages that I have released since last time.

A while ago I decided that I would not longer support 9i based installs. But just last week (May 2009) someone contacted me about a failed install on 9.2. I received the install errors which were:

1. MDSYS.ST_GEOMETRY does not exist (those functions that depend on this are moved to an new package called ST_GEOM);
2. MDSYS.VERTEX_TYPE install problems related to the fact that at 9i MDSYS.VERTEX_TYPE was created (related to MDSYS.SDO_UTIL.GETVERTICES) but that it did not include the id field (introduced at 10g) and;
3. At 9i the MDSYS prefix is required on SDO_GEOMETRY etc but not at 10g (public synonyms exist).

So, I responded to the reported issues by re-casting the packages such that they would compiled on 9i.

The new packages are available here

I have downloaded, installed and tested the scripts against a fresh 9.2.0.1 Enterprise Edition database. All tests passed which was very pleasing.

I develop on 10g Enterprise Edition. The code should recognise when the host is Standard Edition and thus only use Locator functionality but something accidently may “go through to the keeper!”.

Please let me know if you have issues with Locator or any other version.