This week's book giveaway is in the Design forum.
We're giving away four copies of Design for the Mind and have Victor S. Yocco on-line!
See this thread for details.
Win a copy of Design for the Mind this week in the Design forum!
  • 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="" 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>
<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)"/>


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

And my store procedure is

and i am calling like this

Please tell me where i am wrong.

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