This discussion is archived
3 Replies Latest reply: Feb 18, 2013 11:42 PM by Christian Erlinger RSS

cursor condition to be change dynamically

942420 Newbie
Currently Being Moderated
Hi,

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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points