Invoking a stored procedure using hibernate

Stored procedures may be a thing of the past but sometimes they can be very helpful. They reduce network traffic and can perform efficient and fast computations if required.
<sql-insert callable="true">
{call insertClient(?,?,?,?,?,?)}
</sql-insert>
This example may be very trivial but really complex computations can be performed using stored procedures. The drawback with hibernate and stored procedures is hibernate session cache cannot track any modifications done using a stored procedure.