ARCSDESQLEXECUTE and ORACLE stored procedures

2275
2
Jump to solution
04-15-2010 02:21 PM
RyanLuedey
New Contributor
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.
0 Kudos
1 Solution

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

View solution in original post

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

View solution in original post

AndresCastillo
MVP Regular Contributor

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

0 Kudos