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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only