Results 1 to 2 of 2
  1. #1
    Join Date
    May 2007
    Posts
    1

    Unanswered: Informix sp and out parameter

    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.

  2. #2
    Join Date
    Aug 2006
    Location
    The Netherlands
    Posts
    248
    Hi, I'm not familiar with the properties if an OUT parameter of C# but a SP can be invoked in dbaccess like this:
    Code:
    EXECUTE PROCEDURE test(argument)
    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.
    Last edited by Tyveleyn; 05-14-07 at 05:18.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •