Hi,

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?