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"

Hi with dynamic-insert or dynamic-update true it differs the number of parameters time to time. IS there any method to call stored procedures with those dynamic properties enabled
can any one help me on this.....