Hi Mark,
I've followed your suggestion of creating a different named query for each different expected resultset.
However, I'm having some problems with this. The SP call succeeds the first time, however when I call it the second time. Hibernate throws an "Invalid column name" exception and I can only get the SP working by restarting my Websphere server (i.e. starting a new Hibernate session and sessionfactory).
I guess this is the oddest error I've faced in Hibernate
[ January 21, 2008: Message edited by: Paulo Sebasti�o ]