Select to view content in your preferred language

Edit sdo_geometry in ArcGIS Pro

365
2
05-29-2024 08:28 AM
Labels (3)
CGpp
by
Emerging Contributor

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.

0 Kudos
2 Replies
George_Thompson
Esri Notable Contributor

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.

--- George T.
0 Kudos
CGpp
by
Emerging Contributor

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.

0 Kudos