I use:

SQLEXEC(handle,"{Call MyFunction()}")

For example..

cinit=ALLTRIM(gcinit)
cDB=ALLTRIM(cdb)
cMainkey=ALLTRIM(cMainkey)
cfunction=gettable("UpdatePdmLog")
cType=ALLTRIM(cType)
cOldLinekey=ALLTRIM(cOldLinekey)
cNewLineKey=ALLTRIM(cNewLineKey)
cData=ALLTRIM(cData)
cStatus1=ALLTRIM(cStatus1)
cStatus2=ALLTRIM(cStatus2)
cAdmStatus=ALLTRIM(cAdmStatus)
cAdmStatu2=ALLTRIM(cAdmStatu2)
cAdmCode=ALLTRIM(cAdmCode)

lcSQL="{Call "+cfunction+"(?cinit,?cDB,?cType,?cMainkey,?cOldLinekey,?cNewLineKey,?cData,?cStatus1,?cStatus2,?cAdmStatus,?cAdmStatu2,?cAdmCode,?nRec)}"
nerror=SQLEXEC(gnconnectionhandle,lcsql)

This shows how to use bind variables which of course has performance advantages.


In addtion:

http://govt.oracle.com/~tkyte/ResultSets/index.html
This page tells all about returning results sets.
There is an ODBC example writen in VB

However, I tried it about 6 months ago and was unable to get it to work in VFP.
If you succeed let me know.