Hi,

I think u need to use dynamic sql. depending on the parameters passed u need to build ur sql stmt and then execute it...

Srini