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.