Oracle backend

[Steve Weeks]

Does anybody have experience with Oracle as the backend?

I have successfully created an api to ‘see’ the data that has been serialized using the GeoFeatureModelSerializer. Everything works great and appears in the admin page. I can also see the geometry of the data by extending the admin class with the OSMGeoAdmin class.

However if I edit or add a new feature, I get an error as follows:

DatabaseError at /admin/api/airport/

ORA-12801: error signaled in parallel query server P002, instance 1 ORA-06502: PL/SQL: numeric or value error ORA-06512: at “MDSYS.SDO_CONSTRUCT_DIM_ARRAY”, line 33 ORA-06512: at “MDSYS.SDO_CONSTRUCT_DIM_ARRAY”, line 22 ORA-06512: at “MDSYS.SDO_UTIL”, line 848

Request Method:
GET
Request URL:
http://127.0.0.1:8000/admin/api/airport/
Django Version:
4.2
Exception Type:
DatabaseError
Exception Value:
ORA-12801: error signaled in parallel query server P002, instance 1 ORA-06502: PL/SQL: numeric or value error ORA-06512: at “MDSYS.SDO_CONSTRUCT_DIM_ARRAY”, line 33 ORA-06512: at “MDSYS.SDO_CONSTRUCT_DIM_ARRAY”, line 22 ORA-06512: at “MDSYS.SDO_UTIL”, line 848
Exception Location:
C:\python38\lib\site-packages\django\db\utils.py, line 98, in inner
Raised during:
django.contrib.admin.options.changelist_view
Python Executable:
C:\python38\python.exe
Python Version:
3.8.1
Python Path:
[‘C:\Users\steve\OneDrive\Documents\Work\Django\restDemo\mysite’, ‘C:\python38\python38.zip’, ‘C:\python38\DLLs’, ‘C:\python38\lib’, ‘C:\python38’, ‘C:\Users\steve\AppData\Roaming\Python\Python38\site-packages’, ‘C:\python38\lib\site-packages’]
Server time:
Fri, 08 Mar 2024 13:12:22 +0000

When I query the database using SQL Developer I can see that the row has been inserted but there is a problem with the geometry. Below is a JSON output of the feature geometry, which has not been created correctly:

“geometry” : “MDSYS.SDO_GEOMETRY(NULL, 4326, NULL, NULL, NULL)”

This is how it should look:

“geometry” : “MDSYS.SDO_GEOMETRY(2001, 4326, MDSYS.SDO_POINT_TYPE(-86.9205944444444, 12.7689611111111, NULL), NULL, NULL)”