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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement