9 Replies Latest reply: Jun 25, 2012 6:11 AM by Sudipto Desmukh RSS

    Missing IN or OUT parameters error -filtering treeModel using VL Accessor

    Sudipto Desmukh
      Hi All ,
      jdev 11.1.1.6 , ADF BC
      I am trying to filter a leaf node of a tree hierarchy using Frank's example @ Pg 12 - http://www.oracle.com/technetwork/developer-tools/adf/learnmore/feb2011-otn-harvest-328207.pdf

      I try to do this in a AM method -
      if (r != null) { RowSet rs = (RowSet)r.getAttribute("EmployeesView");
      if (rs != null) { ViewObject accessorVO = rs.getViewObject();
      //applyViewCriteria on accessorVO now...
      But somehow after I get the ViewObject the ViewLink paramValues become null due to which I get the error
      java.sql.SQLException: Missing IN or OUT parameter at index:: 2
      after I do accessorVO.executeQuery()...

      I also see a message immediately after I get the accessorVO in the code bit mentioned above
      <accessor VO name via ViewLink reference> ViewRowSetImpl.setParamValues params changed.
      The Rowset rs has the params in it when I inspect the same :(

      Can anyone help with what I am missing.