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