Weird. I could have sworn that I tested my code on both ODBC drivers.

Returning of a record set from a SP was a major learning experience for me. No one knew how to do it so I was doing what you suggest below. I finally found a way! I've been meaning to put together a document for the Thread but have not gotten around to it. Here is a link to the information that got me headed in the right direction. If you would like more info after reading this let me know and I will send you samples of my stored procedures that return cursors.

http://www.orafans.com/ubb/Forum19/HTML/000530.html

George

>Hi!
>
>Did not worked for me with Oracle Driver and worked with MS driver for Oracle. Thanks anyway.
>
>One more question: Is there an ability to return a record set from the SP in Oracle in a single SQLEXEC call? Yet I required to store the result into the temporary table and than query it by a separate call to Oracle server. It there a better way?
>
>TIA.
>
>>Vlad,
>>
>>I usually use:
>>
>>SQLEXEC( nHandle, '{CALL MyStoredProcedure}'
>>
>>HTH,
>>George
>>
>>>Hi!
>>>
>>>When I try following:
>>>
>>>SQLEXEC(nHandle, 'EXECUTE MyStoredProc')
>>>
>>>I get connectivity error 'invalid SQL statement' from ODBC.
>>>If I try to use
>>>SQLEXEC(nHandle, 'BEGIN EXECUTE MyStoredProc; END;')
>>>
>>>It says "Encountered symbol 'MyStoredProc' when expecting := ...", and := is assumed by default as if EXECUTE is not a correct command.
>>>
>>>What is the correct syntax? Is it possible to run Oracle SP from VFP? How?
>>>
>>>TIA