Go to content Go to navigation and search


Free Software Download

Download Code, Packages and Installers

Object Documentation

Package Documentation

Spatial Companion For Oracle (SC4O)


    New versions of LINEAR, CENTROID and GEOM etc packages
    TESSELATE and CENTROID package updates
    Applying and Extending Oracle Spatial: Source Code Problem
    CENTROID package use with ESRI's sde.st_geometry
    Changes to CENTROID and TESSELATE packages
    CENTROID Package now returns centroid of multi-linestring
    New versions of PL/SQL packages uploaded
    New Release of Free PL/SQL Packages
    New version of PL/SQL packages released
    New Version PL/SQL Spatial packages released
    New PL/SQL Package Upload
    PL/SQL Spatial Types and Packages
    Update to PL/SQL Packages
    New PL/SQL Packages
    VB6 Oracle Spatial or Locator OO4O code
    Spatial PL/SQL Packages by Example
    Catalog Registry Tool
    Image Catalog Tool
    Oracle Spatial PL/SQL and VB6 Source Code



RSS / Atom

Email me


Creative Commons License
All Blog Articles, Data Models and Free Source Code by Simon Greener, The SpatialDB Advisor is licensed under a Creative Commons Attribution-ShareAlike 3.0 Unported License.

New Release of Free PL/SQL Packages

Thursday December 10 2009 at 23:02

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

Creative Commons License

post this at del.icio.uspost this at Diggpost this at Technoratipost this at Redditpost this at Farkpost this at Yahoo! my webpost this at Windows Livepost this at Google Bookmarkspost this to Twitter