Hibernate 3 support Custom SQL as follows:

<class name="Person">
<id name="id">
<generator class="increment"/>
</id>
<property name="name" not-null="true"/>
<sql-insert callable="true">{call createPerson (?, ?)}</sql-insert>
<sql-delete callable="true">{? = call deletePerson (?)}</sql-delete>
<sql-update callable="true">{? = call updatePerson (?, ?)}</sql-update>
</class>

Could you give me an java code-example to demonstrate how to call them?

Thanks!

Just use any other example on how to insert, delete and update hibernate objects - there is no difference.

Thanks max.

I haven't done the test yet. I still have one question:
How does Hibernate know the right order of the parameters?

Because in the mapping file we just use quesion marks to describe the stored procedure. How does hibernate know which question mark represents which field?

(BTW: I won't forget to rate :) )

As stated in the docs, currently it is hard coded against what hibernate wants them to be. See in the docs how you by enable debug logging can see what the sequence is.