Call to Oracle procedure in Python

Question

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.

LuisCÃ_spedes · Answer

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.

LoganPugh · Answer

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.