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)?
see this link and @HannesZiegler 's response regarding oracle-python 3
Fix cx_Oracle incompatibility with ArcGIS Pro 3.3 - Esri Community
I use ArcSDESQLExecute for querying non-spatial databases too. Your mileage may vary as the SQL gets more complex.
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've been able to use ArcSDESQLExecute as a replacement for basic things.
Signed in members can post, follow updates, and more. New here? Register a free account.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
