This week's giveaway is in the Spring forum.
We're giving away four copies of REST with Spring (video course) and have Eugen Paraschiv on-line!
See this thread for details.
The moose likes Object Relational Mapping and the fly likes Invalid column name while calling store procedure Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Invalid column name while calling store procedure" Watch "Invalid column name while calling store procedure" New topic

Invalid column name while calling store procedure

pankaj semwal
Ranch Hand

Joined: Oct 07, 2008
Posts: 303
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

Joined: Oct 25, 2008
Posts: 2700

Does the procedure run correctly as you invoke it directly?
By the way: who is List[]?

"Any fool can write code that a computer can understand. Good programmers write code that humans can understand." --- Martin Fowler
Please correct my English.
I agree. Here's the link:
subject: Invalid column name while calling store procedure
It's not a secret anymore!