The report is coming back from Oracle. It is having trouble executing your stored procedure. Have you tested your stored procedure? Have you tested it over a normal JDBC connection?
One thing to note. The connection pool returns a WrappedConnection which may affect things if your call returns you some Oracle specific format data. However, this is the last thing to check - hopefully you are not retrieving Oracle specific data types.
Well, I have a doubt in this regard - is there any means of finding in the jboss 3.0.7 server side and not in the Oracle 8 database server side,
how many connections are there in the pool,
how many connections are in use and
how many connections are being returned at a given point of time?