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.

タグ付けされた投稿をもっと見る

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

会話に参加する

サインインしたメンバーは投稿、更新のフォローなどができます。初めてですか？無料アカウントを登録してください。

クイックリンク

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