Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Call Oracle store procedure
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00647076
Message ID:
00647271
Views:
32
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
Previous
Reply
Map
View

Click here to load this message in the networking platform