Connection to Oracle DB (non geodb)

[MarcoBelotti]

Hi all,

I need to write data in an Oracle DB table from ArcGIS Pro. The Oracle DB is not a geodb.

I can connect to the Oracle DB and add the table to the current map, I can open the table and view the content but I can't add rows or modify any field value.

The user I use to connect to oracle has read/write privileges.

I'm using ArcGIS pro 2.9, Oracle 12 and Oracle client 64 bit on a MS Windows Server 19 Datacenter pc.

I need to do this from a python geprocessing tool I'm writing. The tool must read from an Oracle table, performs some operations and write some results in another Oracle table (not geo).

Does anybody have any ideas or suggestions?

Thanks in advance.

[George_Thompson · Accepted solution]

You cannot edit the records in a non-geodatabase directly from the Pro client: https://pro.arcgis.com/en/pro-app/latest/help/data/databases/databases-and-arcgis.htm#ESRI_SECTION1_...

You cannot connect directly to most supported databases* from ArcGIS Pro and edit the data.

---

If you need to edit, then enable the Enterprise Geodatabase. You could update the records via SQL outside of ArcGIS Pro. You may be able to publish the data as a feature service and edit that way.