Re: Passing a parameter to a Where Clause in PL/SQL !

Hi,

> d_column = nvl(ai_str3, d_column)
> Would that work or what do you think I should do?

It works.

I used something like that in a procedure

PROCEDURE something (vn_param_1 NUMBER, vn_param_2 NUMBER DEFAULT NULL) IS
  CURSOR Cur_stuff IS
    SELECT *

      FROM a
     WHERE attribute_1 = vn_param_1
       AND attribute_2 = NVL(vn_param_2, attribute_2);