General information
Title:
Calling Oracle SP via SPT?
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only