>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.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao