Parameters in SQL query

[ales]

Of course, I made silly mistake (hope only this one):

IF p_cn!=0 THEN
WC:=WC||' AND CN='||to_char(p_cn);
END IF;

IF p_in!=0 THEN
WC:=WC||' AND IN='||to_char(p_in);
END IF;

IF p_tn!=0 THEN
WC:=WC||' AND TN='||to_char(p_tn);
END IF;

Ales