• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Invalid column name while calling store procedure

 
pankaj semwal
Ranch Hand
Posts: 303
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi List[],
I am calling store procedure as i am using oracle database .But i am getting the following exception:


My Hbm file
<class name="hmil.com.partmaster.model.REMPIM_TB" table="REMPIM_TB" >
<composite-id >
<key-property name="MPIM_CMPN_NO" type="java.lang.String" ></key-property>
<key-property name="MPIM_CORP_NO" type="java.lang.String" ></key-property>
<key-property name="MPIM_PART_NO_FRM" type="java.lang.String" ></key-property>
<key-property name="MPIM_PART_NO_TO" type="java.lang.String" ></key-property>
<key-property name="MPIM_EMP_NO" type="java.lang.String" ></key-property>
</composite-id>
<property name="MPIM_VALID" column="MPIM_VALID" type="java.lang.String" />
<property name="MPIM_VALID_FROM" column="MPIM_VALID_FROM" type="java.sql.Date" />
<property name="MPIM_VALID_TO" column="MPIM_VALID_TO" type="java.sql.Date" />
<property name="MPIM_CRTE_DTIME" column="MPIM_CRTE_DTIME" type="java.sql.Timestamp" />
<property name="MPIM_CRTE_EMP_NO" column="MPIM_CRTE_EMP_NO" type="java.lang.String" />
<property name="MPIM_UPT_DTIME" column="MPIM_UPT_DTIME" type="java.sql.Timestamp" />
<property name="MPIM_UPT_EMP_NO" column="MPIM_UPT_EMP_NO" type="java.lang.String" />
<property name="MPIM_EMP_NAME" formula="FNC_GET_EMPLYEE('H','A10AA','A10AA',MPIM_EMP_NO)"/>

</class>

<sql-query name="checkPart" callable="true">
<return class="hmil.com.partmaster.model.REMPIM_TB">
<return-property name="partFrom" column="MPIM_PART_NO_FRM"/>
<return-property name="partTo" column="MPIM_PART_NO_TO" />
</return>
{ CALL PROC_PARTCHECK(?,:partFrom,:partTo) }
</sql-query>

And my store procedure is
:

and i am calling like this



Please tell me where i am wrong.

Thanks
 
Wouter Oet
Saloon Keeper
Posts: 2700
IntelliJ IDE Opera
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Does the procedure run correctly as you invoke it directly?
By the way: who is List[]?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic