Community
Select to view content in your preferred language

cx_oracle for py 3.x?

233
4
a month ago
JamesCrandall
by MVP Frequent Contributor
MVP Frequent Contributor
a month ago

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

 

0 Kudos
4 Replies
BlakeTerhune
by MVP Regular Contributor
MVP Regular Contributor
a month ago

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

JamesCrandall
by MVP Frequent Contributor
MVP Frequent Contributor
a month ago

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.

 

0 Kudos
BlakeTerhune
by MVP Regular Contributor
MVP Regular Contributor
a month ago

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

0 Kudos
DanPatterson
by MVP Esteemed Contributor
MVP Esteemed Contributor
a month ago

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

Fix cx_Oracle incompatibility with ArcGIS Pro 3.3 - Esri Community


... sort of retired...