Go to content Go to navigation and search


Software Documentation


SQL Server

Oracle Objects (New)

Oracle Packages (Original)

Spatial Companion For Oracle (SC4O)


    PL/SQL Objects from "Applying and Extending Oracle Spatial"
    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
    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 versions of PL/SQL packages uploaded

Thursday August 25 2011 at 02:15

It has been a while (GeoRaptor took all my free/spare time) but I have uploaded a new version of the existing free PL/SQL packages to my website.

The changes include:

  • Slow migration away from old Types eg VectorSetType to new types T_Vectors that are shared with other packages not in this zip file (GEOPROCESS, LINEAR, SDO_ERROR etc);
  • Performance improvement of some critical functions cf GetVector;
  • Addition of new functions eg GEOM.concatLines, GEOM.Polygon2Rectangle, GEOM.Rectangle2Polygon etc;
  • Slow rationalisation/removal of old functions needed for 9i.

I have updated the Windows install.cmd file but NOT the install.sh as I do not have
a Linux/unix vm currently on my server (I am working on it but there is only me and I am doing all this Java and PL/SQL work AND GeoRaptor for SQL Developer in my own time!). If you compare the two you should be able to work out what has changed and make the relevant changes. If you do this, and get it to work, please send it to me via email for inclusion in the packages.

Finally, I have updated the installer so that it checks the schema into which you are installing the packages (if you chose not to let the installer create its own – which most DBAs do not like) has the required permissions. If you do not it will stop. Check the log to see what permission is required.

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