SpatialDB Advisor

RSS / Atom

Email me

New Release of Free PL/SQL Packages

Today I uploaded a new release of my free PL/SQL packages.

The release includes:

• GML to SDO conversion for 10g users (involves need to compile and install java code and JAVAGEOM package);
• Ability to execute external applications (see this article for an example) from within the database ;
• New DEBUGPKG for use when developing new PL/SQL functions and procedures;
• Fixes to the KML package;
• Move of constants from GEOM package to the CONSTANTS package;
• Modification Windows installation script to automatically compile and load required java source and classes;
• Addition of UpdateSdoMetadata procedure to TOOLS package;
• Addition of ST_NumGeometries and ST_GeometryN functions to ST_Geom package;
• Fixed arc handling bug in ExtractElementsPiped function in GEOM package;
• Fixed geodetic SRID handling bug in Spit function in GEOM package.

Plus other changes.

The packages are available here

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.

Previous