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.

Oracle Spatial PL/SQL and VB6 Source Code

Saturday August 19 2006 at 17:49

Finally, I have finished enough recoding of my PL/SQL packages and object types for Oracle Locator/Spatial to make them available on my site.

The oracle_spatial_packages_and_types.zip file contains all my Oracle Spatial Packages and Types.

The package should be installed into a schema called CODESYS. A create_schema.sql script is supplied which should be run as system. Then, the install.cmd Windows batch file should be run to install the packages etc into the schema. (If you are installing on Linux or Unix have a look inside the cmd tool and modify accordingly.)

The zip file contains:

  1. A Constants Package;
  2. A COGO (Coordinate Geometry) Package;
  3. A GEOM package containing some useful functions;
  4. A GF (Geometry Factory) Package used to iterate over the elements of an Sdo_Geometry object;
  5. A TESSELATE package containing some QuadTree and Spatial_Key functions;
  6. An MBR Type + Methods for creating and manipulating MBRs;
  7. An ST_Point Type + Methods for managing a simple 4D point object.

There are many things in these packages that probably need re-writing but they are there for all to use as long as I get any updates given back to me and some sort of acknowledgement as the original author.

Also, I have included the read-only VB6 library I wrote over the past few years that uses OO4O to allow VB6 applications to read Oracle Sdo_Geometry. The VB6 classes enable the reading Oracle Spatial (or Locator) data and converting it into a number of formats. It requires OO4O and has been tested up to 10gR2. The package does NOT write Oracle Spatial data. Any improvements (there are some in the ported version of the code in the GF PL/SQL package), please send them back to me.

No liability is accepted for bugs or malfunctions in these packages when used in any production systems.

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