ARCSDESQLEXECUTE and ORACLE stored procedures

[RyanLuedey]

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.

[DallasShearer · Accepted solution]

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

[AndresCastillo]

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