Oracle spatial functions without Oracle spatial extensions

1
votes

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

1
oracleplsqlspatialoracle-spatial
does it really need to be done in Oracle? Could you use PostGIS instead? - ninesided
oh, and what kind of licence do you have for your Oracle installation? Standard? Enterprise? - ninesided
The difficulty lies in having to implement these features in Oracle without spatial extensions and not on another database. - antferr
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production - antferr
Your database installation already includes Oracle Locator. To confirm, just do: "SQL> describe sdo_geometry". If that fails, then somehow your DBA choose to explicitly remove it (or not install it when he/she created the database) but that is very unlikely. Adding it back in is trivial for the DBA (using the Database Configuration Assistant). Locator provides full support for all 2D vector processing. Spatial extends it with 3D vectors, rasters, point clouds, networks, geocoding and more. - Albert Godfrind

1 Answers

1
votes

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.