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-...
Is it possible edit sdo_geometry in Esri products without enabling enterprise geodatabase and without using ST_GEOMETRY?
Thanks.
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_...
It should work for SDO_Geometry if configured correctly.
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.