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

[LinaAl-Jadir]

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.

[JamesCrandall]

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

[CarrieButler · Accepted solution]

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

[AndresCastillo]

https://community.esri.com/t5/geoprocessing-questions/arcsdesqlexecute-and-oracle-stored-procedures/...