I am creating a Query using.. EntityManager.createNativeQuery(queryStr);

where queryStr = "{call INSERT_STORED_PROC (:param1,:param2,..... :param76)}"

This works for every scenario except one, which makes me think the problem lies with the parameters passed dynamically. I have logged all the parameters and compared the working scenarios and the erroneous one. All the data are similar. When i construct the SQL query manually by copying the JDBC parameters logged and run it in SQL developer, it works fine! Where do i proceed from here?!

Error :

PLS-00306: wrong number or types of arguments in call to 'INSERT_STORED_PROC'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute native bulk manipulation query; SQL [{call INSERT_STORED_PROC(:param1,:param2,..... :param76)} ]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute native bulk manipulation query

at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:629)