0 Replies Latest reply: Mar 4, 2014 5:54 AM by 92180189-65a4-42b1-858e-d53bb6019e8e RSS

    Bind Variable Issue

    92180189-65a4-42b1-858e-d53bb6019e8e

      How to set values of bind variable that is used in where clause of view object query

       

      Below is my Query

       

      SELECT MODE_ID

      FROM  XXWS_MODE_MASTER

      WHERE                 1 = 1

      AND INSTR((SELECT '|' || XXWS_UTIL_PKG.F_DEC_TO_BIN (NVL(:MODE_SUMMATION,0) ) FROM DUAL ),'|'||MODE_ID) > 0

       

       

      MODE_SUMMATION is a value from different table .I Have Created this query based view object only for populating LOV

       

       

      I am using below code in Managed Bean for setting value of bind variable MODE_SUMMATION

         ViewObject vo = am.findViewObject("LOVPopulateVO1");

                      VariableValueManager vm = vo.ensureVariableManager();

                      vm.setVariableValue("MODE_SUMMATION",modeSum);

                      vo.executeQuery();