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

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