Hi,
I have a working odbc connection between progress and an informix database. The problem is that when calling a stored procedure I can't fetch the return values. I have tried different ways to call the procedure:
RUN STORED-PROC sp_name handle1 = PROC-HANDLE
( INPUT PARAM user = "gral", INPUT PARAM h_site = 255, INPUT PARAM h_cust_id = 10).
FOR EACH proc-text-buffer:
DISP proc-text-buffer.
END.
CLOSE STORED-PROCEDURE sp_name.
This runs with no errors but I dont get anything in return. When I add one (or more) output parameters to the call I get an error from the informix ODBCdriver that I passed too many parameters to the procedure, but there are 37 returned values from the stored procedure.
Hope someone can give me some ideas what might be wrong.
Thank you
/Teresia
I have a working odbc connection between progress and an informix database. The problem is that when calling a stored procedure I can't fetch the return values. I have tried different ways to call the procedure:
RUN STORED-PROC sp_name handle1 = PROC-HANDLE
( INPUT PARAM user = "gral", INPUT PARAM h_site = 255, INPUT PARAM h_cust_id = 10).
FOR EACH proc-text-buffer:
DISP proc-text-buffer.
END.
CLOSE STORED-PROCEDURE sp_name.
This runs with no errors but I dont get anything in return. When I add one (or more) output parameters to the call I get an error from the informix ODBCdriver that I passed too many parameters to the procedure, but there are 37 returned values from the stored procedure.
Hope someone can give me some ideas what might be wrong.
Thank you
/Teresia