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.