Michael,

You may need to make sure the string you send is long enough for the result. Try:

outParam = SPACE(255)
sqlresult= sqlexec(gnConnHandle,"{ call test ('DOIT',?@outParam) }")

>I am trying to send and retrieve data from a stored procedure on our oracle server using visual foxpro and ODBC.
>
> Client:
> VFP and ODBC
> Server:
> ORACLE procedure
>
>
>
>I can connect and send a charactor string and return a number value from the stored procedure. But when I change the VFP call and ORACLE procedure to a string the call returns a memory error.
>
>
>The VFP code is:
>
>outParam = 'hi'
>sqlresult= sqlexec(gnConnHandle,"{ call test ('DOIT',?@outParam) }")
>
>
>The ORACLE code is:
>
>(var_one IN varchar, var_two IN OUT varchar)
>AS
>
>begin
>
> var_two := ' you';
>
>end;
>
>****
>The error appears to be related to not finding the proper address.