nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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.

Vind meer berichten getagd met

Accepted answers

CarrieButler

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

All comments

AndresCastillo

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

CarrieButler

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

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

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.