stored procedure with return value

Posted in 1999

Bert de Wit — Tue, 31 Aug 1999 09:20:06 +0200 — source: Informix-list mailing list archive (1991-1998)

I want to call a stored procedure with a return value on Informix using the ODBC syntax: {?= call sp_myproc(?)} I am programming on de OLE DB interface and tried using the Informix OLE DB provider and the OLE DB Provider for ODBC with the Intersolv ODBC Driver. Calling the same procedure on SQL Server works fine, Informix does not return the value in the bound parameter (?=) but in a rowset instead. Does somebody have a hint or ins't possible to call a stored procedure with bound output parameters on Informix through ODBC? Bert de Wit WinIt Software Engineering