>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
Hi Isaac,
i cannot tell you about Oracle. But concerning Sybase Anywhere (a product i user daily) u certainly can request a server-side procedure to return a cursor into odbc (as an alternative to return a single param or nothing).
In this case the server syntax is sqlexec(myHandle,"CALL MYFUNCTION",mycursor) instead of the usual sqlexec(myHandle,"SELECT ...",mycursor)