Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Calling Oracle SP via SPT?
Message
From
13/09/1999 14:21:19
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Calling Oracle SP via SPT?
Miscellaneous
Thread ID:
00264121
Message ID:
00264121
Views:
66
Our DBA has asked that we call a stored procedure (SP)
prior to invoking any long quiries. The SP will capture
the time the program starts and stops.

I am using VFP 6 and SQL passthru to execute my programs.

When I try to use SQLEXEC(gnhandle,"EXECUTE sp_name('test')")
I get "invalid sql statement" back as an error.

How can I call an Oracle 8 stored proc from VFP via
SQL passthru?
Next
Reply
Map
View

Click here to load this message in the networking platform