I have a stored proc that creates a temp table

can i create a mapping to a temp table in hibernate

Create configuration programmatically on the fly and get session from it, we can work with two or more sessions simultaneously. Depends on your application you might want to implement transaction propagation between them.
Or you can use native SQL support in Hibernate
http://www.hibernate.org/hib_docs/v3/re ... l-creating