<div class="gmail_quote">Dear Experts,<br><br>I have an issue with the Hibernate custom sql commands. I have the mapping file:<br><br><i>&lt;?xml version=&quot;1.0&quot;?&gt;<br>&lt;!DOCTYPE hibernate-mapping PUBLIC<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &quot;-//Hibernate/Hibernate Mapping DTD 3.0//EN&quot;<br>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &quot;<a href="http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd" target="_blank">http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd</a>&quot;&gt;<br><br>&lt;hibernate-mapping&gt;<br>&nbsp;&nbsp;&nbsp; &lt;class name=&quot;com.gsk.europepharma.clinfit.model.entities.InputFile&quot; table=&quot;INPUT_FILE&quot; schema=&quot;CLINFIT&quot;&gt;<br>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;id name=&quot;id&quot;&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;column name=&quot;ID&quot; sql-type=&quot;number&quot; length=&quot;10&quot; precision=&quot;0&quot; not-null=&quot;true&quot;/&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;generator class=&quot;sequence&quot;&gt;<br>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;param name=&quot;sequence&quot;&gt;S_INPUT_FILE&lt;/param&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/generator&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/id&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name=&quot;fileType&quot;&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;column name=&quot;FILE_TYPE&quot; sql-type=&quot;varchar2&quot; length=&quot;20&quot; precision=&quot;0&quot; not-null=&quot;true&quot;/&gt;<br>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/property&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name=&quot;forDate&quot;&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;column name=&quot;FOR_DATE&quot; sql-type=&quot;date&quot; length=&quot;7&quot; precision=&quot;0&quot; not-null=&quot;true&quot;/&gt;<br>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/property&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name=&quot;statusCode&quot;&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;column name=&quot;STATUS_CODE&quot; sql-type=&quot;varchar2&quot; length=&quot;20&quot; precision=&quot;0&quot; not-null=&quot;true&quot;/&gt;<br>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/property&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name=&quot;datetimeLastProcessed&quot;&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;column name=&quot;DATETIME_LAST_PROCESSED&quot; sql-type=&quot;date&quot; length=&quot;7&quot; precision=&quot;0&quot; not-null=&quot;false&quot;/&gt;<br>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/property&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name=&quot;datetimeStatusLastChanged&quot;&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;column name=&quot;DATETIME_STATUS_LAST_CHANGED&quot; sql-type=&quot;date&quot; length=&quot;7&quot; precision=&quot;0&quot; not-null=&quot;true&quot;/&gt;<br>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/property&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name=&quot;invalidDataMessage&quot;&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;column name=&quot;INVALID_DATA_MESSAGE&quot; sql-type=&quot;varchar2&quot; length=&quot;1000&quot; precision=&quot;0&quot; not-null=&quot;false&quot;/&gt;<br>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/property&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;many-to-one name=&quot;country&quot; class=&quot;com.gsk.europepharma.clinfit.model.entities.CCountry&quot;&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;column name=&quot;COUNTRY_ID&quot; not-null=&quot;true&quot;/&gt;<br>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/many-to-one&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;!-- TODO: comment it --&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;sql-update callable=&quot;true&quot;&gt;{ ? = call BUSINESS_LOGIC_PKG.CHANGE_INPUT_FILE_STATUS (?, ?, ?, ?, ?, ?, ?, ?)}&lt;/sql-update&gt;<br>

&nbsp;&nbsp;&nbsp; &lt;/class&gt;<br>&lt;/hibernate-mapping&gt;</i><br><br>When my objects at runtime are updated I am getting&nbsp; the following Exception:<br><i>Caused by: java.sql.SQLException: Missing IN or OUT parameter at index:: 9<br>

&nbsp;&nbsp;&nbsp; at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)<br>&nbsp;&nbsp;&nbsp; at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)<br>&nbsp;&nbsp;&nbsp; at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1729)<br>

&nbsp;&nbsp;&nbsp; at oracle.jdbc.driver.OraclePreparedStatement.addBatch(OraclePreparedStatement.java:10547)<br>&nbsp;&nbsp;&nbsp; at oracle.jdbc.driver.OracleCallableStatement.addBatch(OracleCallableStatement.java:2009)<br>&nbsp;&nbsp;&nbsp; at org.hibernate.jdbc.BatchingBatcher.addToBatch(BatchingBatcher.java:31)<br>

&nbsp;&nbsp;&nbsp; at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2408)<br>&nbsp;&nbsp;&nbsp; ... 25 more<br><br></i>The update function - <i>BUSINESS_LOGIC_PKG.CHANGE_INPUT_FILE_STATUS </i>is implemented in Oracle 10g R2. Before this I checked the order of parameters with debuging the static queries. I went through the code and I could not find any where registerOutputParameter invocation to the callable statement, so the result can be consumed back to Hibernate. <br>

<br>Can anybody help me!<br><br>Thanks in advance!<br><br>Best regards,<br>Anatoli<br clear="all"><br>-- <br>Anatoli Atanasov<br>mobile: (+359) 888 32 06 49
<br></div><br><br clear="all"><br>-- <br>Anatoli Atanasov<br>mobile: (+359) 888 32 06 49