Select to view content in your preferred language

Call to Oracle procedure in Python

3139
2
03-24-2011 01:21 PM
GaminiGunasekera
New Contributor
Hi,

I am new to python and ARCGIS both.

I am using arcgisscripting to create my database connection, is there a possibility to call a oracle strored procedure within a python script.

I saw some example that call to oracle procedure but that was using cx_Oracle connection.

Thanks in advance.
Tags (2)
0 Kudos
2 Replies
LoganPugh
Frequent Contributor
Take a look at the ArcSDEExecuteSQL command. It lets you execute arbitrary SQL and the help mentions the ability to use stored procedures, but I have not verified that myself.
0 Kudos
LuisCÃ_spedes
Deactivated User
Hi,

I am new to python and ARCGIS both.

I am using arcgisscripting to create my database connection, is there a possibility to call a oracle strored procedure within a python script.

I saw some example that call to oracle procedure but that was using cx_Oracle connection.

Thanks in advance.



Were you able to complete this. I am running into problems as well and the link above did not help me much.
Thanks.
0 Kudos