I just did a search (should have done that prior to posting).
Anyway the way to use an Oracle SP from VFP is as follows:
SQLEXEC(connhandle,"{CALL sp_name(param)}")
>
>When I have problems with sql passthru to Oracle, I sometimes put the Oracle SQL syntax in a VFP memo field. Call the VFP memo field 'sql_code' for example.
>
>Then sqlexec(gnhandle,(sql_code))
>
>Good luck,
>
>Paul
>
>
>>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?
Previous
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