Paul,

Thanks for your reply. Another question: What do I need to do in my stored procedure to return multiple rows to the VFP app?

TIA

Rex

>Hi Rex,
>
>x = sqlconnect()
>
>Assuming you have a connection or DNS for your Oracle database.
>
>y = sqlexec(x,"Oracle_stored_procedure_name","result_set_cursor")
>
>The VFP cursor is your result set.
>
>Good luck,
>
>Paul de Niverville
>
>>I have an Oracle stored procedure which uses SQL to extract data from an Oracle database. I want to run this procedure from VFP and have access to the result set. Is this possible?
>>
>>TIA
>>
>>Rex