topic Run PL/SQL stored procedure (in Oracle) using arcpy in Python Questions

Run PL/SQL stored procedure (in Oracle) using arcpy

LinaAl-Jadir — Tue, 04 Mar 2014 09:25:57 GMT

Using arcpy in a Python script, I can connect to an Oracle database (I use ArcSDESQLExecute) and then run an SQL statement (I use execute).
My question is: is there a way to run a PL/SQL stored procedure using arcpy ?
Thank you.

Re: Run PL/SQL stored procedure (in Oracle) using arcpy

JamesCrandall — Tue, 04 Mar 2014 10:34:55 GMT

I don't think this is possible with arcpy. You would have to implement a 3rd party library like cx_Oracle to do this. We use this library but are simply building the SQL and invoking it runtime, so I don't have specific examples for PL/SQL packages or procedures. But there is plenty of info and examples out there: http://stackoverflow.com/questions/18267935/return-variable-from-cx-oracle-pl-sql-call-in-python

Re: Run PL/SQL stored procedure (in Oracle) using arcpy

CarrieButler — Wed, 22 Jun 2016 17:19:23 GMT

I was able to do this with an existing SDE connection and arcpy.

import arcpy

myConn = arcpy.ArcSDESQLExecute('Database Connections/myConnectionName.sde')

mySQL = 'Call myOraPackageName.myOraProcedure()'

myReturn = myConn.execute(mySQL)

print myReturn

Re: Run PL/SQL stored procedure (in Oracle) using arcpy

AndresCastillo — Tue, 05 Jan 2021 06:36:53 GMT

https://community.esri.com/t5/geoprocessing-questions/arcsdesqlexecute-and-oracle-stored-procedures/td-p/31974#comment-118410