Hi!

That article describes the approach for Oracle OLEDB provider that you cannot use by VFP other way than through ADO. Do you have samples for pure VFP SQLEXEC command?

Thanks!

>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