Connection to Oracle DB (non geodb)

MarcoBelotti — Thu, 02 Dec 2021 12:34:33 GMT

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.

Re: Connection to Oracle DB (non geodb)

George_Thompson — Thu, 02 Dec 2021 13:34:31 GMT

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_A188C2B1C8C54C7DA3233892FC742552

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.

topic Re: Connection to Oracle DB (non geodb) in ArcGIS Pro Questions

Connection to Oracle DB (non geodb)

Re: Connection to Oracle DB (non geodb)