Hi all,
Was provided an old Python 2.7 script that imported cx_Oracle for submitting SQL against an Oracle db. Just curious if there's any replacement for this using the default py libraries that come installed with ArcGIS Pro 3.1.2 (or some version of such)?
I've been able to use ArcSDESQLExecute as a replacement for basic things.
Thank you. I didn't mention that the Oracle db is non-spatial/sde that is being queried. I looked at the actual Sql in the original script and it's quite extensive.
I use ArcSDESQLExecute for querying non-spatial databases too. Your mileage may vary as the SQL gets more complex.
see this link and @HannesZiegler 's response regarding oracle-python 3
Fix cx_Oracle incompatibility with ArcGIS Pro 3.3 - Esri Community