Thank you very much for your help!
>>Hi,
>>
>>It seems that I'm stuck again. I have a store procedure that is returning a cursor and I it gives me error if I try to call it like in your example.
>>Is it some other way to do this?
>>
>>
>>thank you very much
>>
>>
>>>lcSQL = "{call SchemaName.StoredProcName}"
>>>lnRetVal = SQLExec(lnHandle, lcSQL)
>>>
>>>Is your stored proc returning anything [e.g., a cursor]?
>>>
>>>>Can someone please tell me the syntax for calling an Oracle store procedure from Visual FoxPro 6?
>>>>
>>>>
>>>>Thank you very much.
>
>See Message#
620377 for an example of this. The syntax is for the Oracle ODBC Driver only. It doesn't work for the MS ODBC Driver for Oracle.