O'Reilly logo

Applying and Extending Oracle Spatial by Siva Ravada, Simon Gerard Greener

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Packaging or encapsulation functions

Many functions (some dependent on others) have been created, but over time, an even larger library of (possibly interdependent) functions may come into existence, which may increase fragility unless dependencies are managed, and the compilation of each function occurs in the right order. In addition, it may be necessary to call a specific function in different ways even though they all implement exactly the same functionality.

Oracle offers us a number of ways to handle these situations.

Calling the same processing in different ways

The ST_Dimension function must be called with an SDO_GEOMETRY parameter. However, it may be more efficient to call the function with an SDO_GEOMETRY object's SDO_GTYPE numeric attribute; ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required