This week's book giveaway is in the Cloud/Virtualization forum.
We're giving away four copies of Kubernetes in Action and have Marko Luksa on-line!
See this thread for details.
Win a copy of Kubernetes in Action this week in the Cloud/Virtualization forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Invalid column name while calling store procedure  RSS feed

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.

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[]?
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!