topic Re: Edit sdo_geometry in ArcGIS Pro in ArcGIS Pro Questions

Edit sdo_geometry in ArcGIS Pro

CGpp — Thu, 30 May 2024 06:54:27 GMT

Hello,

I am new to Esri products and I appreciate any help. I am trying to edit data (sdo_geometry) in Oracle DB but without success.
1. install ArcGIS Pro 3.3 Standard + connect to Oracle DB (.sde file) - db user with sufficient privilages
2. install ArcGIS Server 11.2 Standard (stand-alone) + Add new ArcGIS Server in my ArcGIS Pro (connection type = Publisher Connection)
3. register a database to my ArcGIS Server (same as publisher database connection)
4. for oracle table I publish map service with feature capabilities (edit geometry + attributes checkboxes checked)
5. add features service to my ArcGIS Pro project and edit status is showing - This layer's workspace is read only. Workspace name: Feature Service Data MY_LAYER_NAME

I also tried to prepare oracle spatial table like in this instruction but the edit status of the layer was the same:
https://support.esri.com/en-us/knowledge-base/set-up-an-oracle-dbms-spatial-table-for-editing-via-a-f-000012057

Is it possible edit sdo_geometry in Esri products without enabling enterprise geodatabase and without using ST_GEOMETRY?
Thanks.

Re: Edit sdo_geometry in ArcGIS Pro

George_Thompson — Wed, 29 May 2024 15:41:57 GMT

What is the version of Oracle?

Can you please confirm that the service has editing permissions: https://pro.arcgis.com/en/pro-app/latest/help/data/databases/databases-and-arcgis.htm#ESRI_SECTION1_A188C2B1C8C54C7DA3233892FC742552?

It should work for SDO_Geometry if configured correctly.

Re: Edit sdo_geometry in ArcGIS Pro

CGpp — Mon, 03 Jun 2024 06:36:02 GMT

Hello,

I edit my post because of adding attachment - permissions of service in arcgis server manager.

Oracle Database 19c Standard Edition Version 19.14.0.0.0. ArcGIS Server is on the same server as database.