Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:
3.1
Name and version of the database you are using:
MS SQL Server

our stored procedures in ms sql server are very complex, one stored procedure would include the insert, update and delete, how can I call those stored procedures that mix with delete, insert, update?

i can only get some information from reference now:

<sql-insert callable="true">{call createPerson (?, ?)}</sql-insert>
<sql-delete callable="true">{? = call deletePerson (?)}</sql-delete>
<sql-update callable="true">{? = call updatePerson (?, ?)}</sql-update>

but it seams that one stored procedure have one function.

how can i do about the problem above? Thanks a lot.

who can help me? I am really appreciate it.

eh why do you think you can't use the same procedure in every call ?
(there is the limitation though that the sp's have to have the right number and sequence of arguments as hibernate expects....read the docs about that one)