Hi. I am new to informix and i'm trying to call informix sp with out parameter from c# using informix oledb provider.

Procedure:
CREATE PROCEDURE "informix".test(OUT paramOut_ integer)

RETURNING CHAR(10);

DEFINE ret_ CHAR(10);

LET ret_ = "rezultat";

LET paramOut_ = 10;

RETURN ret_;

END PROCEDURE;


When i try to execute my program i'm getting error message:
EIX 000 (-9752) argument must be a statement local variable for OUT/INOUT parameter.
Can someone please tell me where is a mistake and how to call this sp from dbaccess because i'm getting the same error message when i try to execute this procedure.

Hi, I'm not familiar with the properties if an OUT parameter of C# but a SP can be invoked in dbaccess like this:Regards

BTW. It seems to me that your parameter declaration '(OUT paramOut_ integer)' is incorrect. At least, I know nothing of the usage of variabletype specifiers in Informix SPL except from 'GLOBAL'. If it's used this way in C# for invoking the SP don't repeat the specification in the SP definition and use only '(paramOut_ INTEGER)' instead.