I think I may have found the answer in message #265156 which suggests doing something like

lnOk = SQLEXEC(gnhandle,"SELECT OracleFunction(parameter) FROM DUAL","MyCursor")

to get the return value as cursor.

>Can anyone enlighten me on the following ...
>
>I have not tried this yet as I do not yet have an Oracle DB setup, but have been told that when using VFP SPT and making a call to an Oracle stored procedure, Oracle stored procedures can only return a value which VFP does not know how to accept? Is this so, or have I been misinformed? If it is so how have any of you handled this?
>
>TIA
>-Isaac