In the documentation following is mentioned in section 18.2.2.1:

You cannot use stored procedures with Hibernate unless you follow some procedure/function rules. If they do not follow those rules they are not usable with Hibernate. If you still want to use these procedures you have to execute them via session.connection().

The session interface doesn't provide such method any more.