Here’s a package with a few functions for getting the start/end point of an sdo_geometry. This package should be dropped and moved in to the

This package mainly contains utility programs that can do things like: Create SDO_GEOM_METADATA records from scratch; Discover SRID; Discover Dimensions in sdo_geometry column; Discover Geometry/Spatial

I have a package that will allow you to convert a single geometry into KML or create a whole KML document from a recordset containing

The CoOrdinate GeOmetry package contains a bunch of functions related to handling curves, circles, bearings and distances.

The GEOM package contains a generic collection of algorithms that work on SDO_GEOMETRY objects. This package needs many TYPES to exist and also depends on

I have written a PL/SQL package called SDO_ERROR that could be used to visualise geometry errors (specifically validate_geometry_with_context) and elements Additionally it focuses mainly on

Required Types Package Header. This package can be downloaded via the download page.