decode (need a sort of dynamic stuff or so)

[Shurik12]

Hi DaPi,

Thanks for your feedback.
Just sorted it out.
One has to use a late binding here.
This one I've encountered myself once. The problem is your way of using bind variables. Rather try the following (late binding):

......
53: AND cd.NAMEID=n.NAMEID
54: AND STOREDATE >= :1 AND STOREDATE <= :2
55: AND CONAME= :3
56: AND MATURITY= :4
57: GROUP BY storedate';
58: OPEN ChartOutput FOR l_query USING p_StoreDateStart, p_StoreDateEnd, p_CompanyName, p_Maturity;

Cheers,
Alex.