topic Re: ARCSDESQLEXECUTE and ORACLE stored procedures in Geoprocessing Questions

ARCSDESQLEXECUTE and ORACLE stored procedures

RyanLuedey — Thu, 15 Apr 2010 21:21:09 GMT

I can't seem to get this combination to work. According to this thread:

http://forums.esri.com/Thread.asp?c=93&f=1729&t=275646

it should be possible. Every time I try it I get an "ORA-00900: invalid SQL statement" error. My SQL statement works fine from TOAD.

Is there a secret to making this work, or does it not work at all? Any ideas?

Cheers.

Re: ARCSDESQLEXECUTE and ORACLE stored procedures

DallasShearer — Fri, 17 Feb 2012 15:16:25 GMT

I had the same problem when using sql = execute mystoredproc()
instead use sql = call maystoredproc() to run successful.

Re: ARCSDESQLEXECUTE and ORACLE stored procedures

AndresCastillo — Tue, 05 Jan 2021 06:35:22 GMT

Marked @DallasShearer response as correct due to the verification given in this Stack Overflow (SO) thread:

https://gis.stackexchange.com/questions/307592/execute-oracle-stored-procedure-from-arcsdesqlexecute