Hi Everyone,

When I run my report through Ireport (Desinger) the report takes about 7 minutes. The report uses an oracle stored procedure to create a temporary table.

When the same report is deployed in Jboss and runs the compiled jasper report the called stored procedure runs for about 5 hours. Why is there such a huge difference in the oracle stored procedure time.

The same stored procedure on an sqlPlus command line takes about 2 minutes.

Any pointers as to where the problem lies will be appreciated

Rgds
Kes