CODEWITHSUNDEEP
oracle-databaseplsqlspatialoracle-spatial
antferr
antferr

Reputation: 100

Oracle spatial functions without Oracle spatial extensions

I need to save the GPS coordinates in an Oracle database on which are not installed spatial extension. There is software pl/sql that emulates the main functions of Oracle Spatial (obviously no use its datatype) in the same way to make a "wrap" of JSON functionality of Oracle 11 exists this project on github: https://github.com/pljson/pljson

Upvotes: 1

Views: 1122

Answers (1)

ninesided
ninesided

Reputation: 23263

Take a look at Oracle Locator, it should be installed by default with all editions of Oracle and gives you access to a subset of the features available in Spatial, including the geometry data types you'd need and hopefully some of the functions too, depending on what you need to do with the data.

To check if you have it installed try the following from SQL*Plus:

SQL> describe sdo_geometry

If this succeeds, it's installed, if not, you'll need to ask your friendly neighbourhood DBA to install it for you.

Upvotes: 1

Related Questions