Thank you very much for your help!
>To return a cursor you need an Oracle package. See:
>
>
Re: Newbie question re: PL/SQL conditional code Thread #
625442 Message #
631727>
>>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.