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.
Mark McCasland
Midlothian, TX USA