Hibernate version:3.1.1
WebLogic 8.1
Sybase 12.5


Hi,
I am using hibernate to call sybase stored procedures. I have got this working in so far that I am calling an SP that doesn't do anything fancy (like using temporary tables!) The data is nicely returned to me in a list of objects mapped in the hbm.xml files. All very nice.

However, I am now trying to call a stored procedure that uses temporary tables created outside the called stored procedure. That is, the client calling the stored procedure creates the temporary tables, calls the sp, the sp inserts rows in to the temporary tables and the client can then work with the result set.
This is what I cannot figure out. I'd like to make use of the named queries that return my data in to a list of java objects that I do not have to do manually wrap, rather than use straight jdbc.


Anyone got any bright ideas or are you too busy watching the World Cup?

Many thanks

Jadiyo