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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only