I am passing date as a Parameter .. Why dou need to do a To_Date... ???Regards,Ganesh ROracle LazyDBA home page