Call to Oracle procedure in Python

Discussion created by gamini on Mar 24, 2011
Latest reply on Jul 26, 2011 by cespel

Like • Show 0 Likes0
Comment • 2

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.

Outcomes

2 Replies

lpugh01 Mar 24, 2011 2:59 PM
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.
Like • Show 0 Likes0
Actions
cespel Jul 26, 2011 11:29 AM
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.
Like • Show 0 Likes0
Actions

GeoNet

The Esri Community

Call to Oracle procedure in Python

Outcomes

Related Content

Recommended Content