Can someone provide an example of how to call a stored procedure on the database using the connection provided by Hibernate. Even if it involves using the JDBC connection directly.
It looks like Hibernate release 3 has better support for stored procs, but please provide example that uses the Hibernate that comes with MyEclipse.