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?
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement