Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Running of the Oracle SP from VFP
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00510968
Message ID:
00511153
Vues:
34
This message has been marked as a message which has helped to the initial question of the thread.
Vlad,

I usually use:

SQLEXEC( nHandle, '{CALL MyStoredProcedure}'

HTH,
George

>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
Everything we see or seems
Is but a dream within a dream
- Edgar Allen Poe
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform