3 Replies Latest reply: Feb 19, 2013 1:42 AM by Christian Erlinger RSS

    cursor condition to be change dynamically


      Using Oracle forms 10g

      I want to change where clause of a cursor depending on if condition.

      Ex: If :block1.item1 IN ('A','B','C') AND :block2.item2 ='D' THEN
      --- cursor c1 with where clause
      ELSIF :block1.item1 ='A' AND :block2.item2 IN ('B','C','D') THEN
      -- cursor c1 having different where clause.
      END IF;

      How to achieve it.

      Thanks in advance.