General information
Title:
Sqlexec and returning data
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.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only