topic Re: cx_oracle for py 3.x? in Python Questions

cx_oracle for py 3.x?

JamesCrandall — Tue, 28 May 2024 18:54:43 GMT

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

Re: cx_oracle for py 3.x?

BlakeTerhune — Tue, 28 May 2024 20:02:00 GMT

I've been able to use ArcSDESQLExecute as a replacement for basic things.

Re: cx_oracle for py 3.x?

JamesCrandall — Tue, 28 May 2024 20:20:47 GMT

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.

Re: cx_oracle for py 3.x?

BlakeTerhune — Tue, 28 May 2024 20:55:10 GMT

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

Re: cx_oracle for py 3.x?

DanPatterson — Tue, 28 May 2024 21:05:58 GMT

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

Fix cx_Oracle incompatibility with ArcGIS Pro 3.3 - Esri Community