Hi!
Thanks everyone, it now works with Oracle driver too!
>Hi again,
>
>Sorry been out of things the last week (software release, you know)
>
>If this thread is still useful...
>
>>SQLEXEC(nHandle, 'BEGIN EXECUTE MyStoredProc; END;')
>>
>>It says "Encountered symbol 'MyStoredProc' when expecting := ...", and := is assumed by default as if EXECUTE is not a correct command.
>
>You don't need the EXECUTE.
>
>It is just
>
>SQLEXEC(nHandle, 'BEGIN MyStoredProc; END;')
>
>
>Les
>
>>Hi!
>>
>>When I try following:
>>
>>SQLEXEC(nHandle, 'EXECUTE MyStoredProc')
>>
>>I get connectivity error 'invalid SQL statement' from ODBC.
>>If I try to use
>>SQLEXEC(nHandle, 'BEGIN EXECUTE MyStoredProc; END;')
>>
>>It says "Encountered symbol 'MyStoredProc' when expecting := ...", and := is assumed by default as if EXECUTE is not a correct command.
>>
>>What is the correct syntax? Is it possible to run Oracle SP from VFP? How?
>>
>>TIA
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.