Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Call Oracle store procedure
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00647076
Message ID:
00647271
Vues:
35
I think SQL Server and Oracle are the same...

Here's a call to SQL server.
  PROCEDURE nextid
  LPARAMETERS tcKeyID

  DoDebug('We are getting new value...')

  LOCAL lcExecute,lnReturn,lnNextID
  lnReturn = 0
  lnNextID = 0

  lcExecute = "exec sp_GetNextKey ?@lnNextID,'"+ALLTRIM(tcKeyID)+"'"

  lnReturn = SQLEXEC(THIS.oConnection.GetHandle(),lcExecute)
  RETURN lnNextID
>Can someone please tell me the syntax for calling an Oracle store procedure from Visual FoxPro 6?
>
>
>Thank you very much.
Heavy Metal Pedal - click with care
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform