AnsweredAssumed Answered

Stored Procedure call in esri python

Question asked by kucukaga on May 15, 2017
Latest reply on Nov 15, 2017 by dblanchardesri-ca-esridist

Hello,

I want to run a stored procedure prepared in the mssql Over the ESRI python

I wrote a code like this, but I get an error on the last line

 

# Create connection
arcpy.ArcSDESQLExecute(server='172.16.200.16', instance='sde:sqlserver:172.16.200.16', database='BYS', user='cbssa',password='Adm18712')
# Execute stored procedure
sql = "EXEC dbo.MyStoredProcedure @id = uSP_DB_IslemYap_CELIKVANA"
db_connection.execute(sql)

Attachments

Outcomes