Re: SQL Function execution using Cayenne

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Fri Oct 07 2005 - 11:41:01 EDT

  • Next message: Andrus Adamchik: "Re: double inner join"

    On Oct 7, 2005, at 1:39 AM, Shah, Megha wrote:

    > The error recieved is:
    >
    > INFO QueryLogger: {? = call TEMP.FN_FC_HOLIDAY_PCS(?, ?)} [bind:
    > NULL,
    > 'KT03', '12345']
    > INFO QueryLogger: {? = call TEMP.FN_FC_HOLIDAY_PCS(?, ?)} [bind:
    > NULL,
    > 'KT03', '12345']
    > INFO QueryLogger: *** error.
    > java.sql.SQLException: Missing IN or OUT parameter at index:: 1
    >
    > Initially I thought it was beacuse there is no 'direction' field in
    > the XML
    > entry for _return_value. But on specifying that, the SQL error
    > returned was
    > "Invalid Column Type".

    You were on the right track... Direction should be OUT. Invalid
    column error was caused by the fact that return type is mapped as
    OTHER. Change it to the return type you expect. Also remove this line
    from the code:

       query.addParameter("_return_value", null);

    Andrus

    This archive was generated by hypermail 2.0.0 : Fri Oct 07 2005 - 11:41:04 EDT