cx_oracle for py 3.x?

Question

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)?

danretired · Answer

see this link and @HannesZiegler 's response regarding oracle-python 3

Fix cx_Oracle incompatibility with ArcGIS Pro 3.3 - Esri Community

blake.terhune · Answer

I use ArcSDESQLExecute for querying non-spatial databases too. Your mileage may vary as the SQL gets more complex.

JamesCrandall · Answer

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.