Hi All,
I don't know if I'm asking it right. I have a jsp for monthly report that calling java class and passing date parameter (year and month) into that java class. The java class has a statement that call procedure in database. It's so time consuming to show the report. But when I do hardcode in procedure for date parameter, the report shows much faster. I already checked the passing parameter and it has correct value. Any idea how this thing can happen? Thanks for your reply.