In our application I tried to use <sql-insert> for call the stored procedures through the hibernate mapping file. as discussed in
http://docs.jboss.org/hibernate/core/3. ... erysql-cud section 16.3

eg:
<sql-insert callable="true">{call createPerson (?, ?)}</sql-insert>

But because we put "dynamic-insert=true" property, Hibernate differs its number of parameters time to time If we doesn't put values on some fields (null). So <sql-insert> doesn't call the stored proceedure as itis.

can any one help me on this. or can any one suggest me to do this in differently with use of the "dynamic-insert=true"