aspose file tools*
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 EJB 3 in Action this week in the EJB and other Java EE Technologies 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: 300
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
Similar Threads
inner query in hibernate
Invalid Column Name
inner query in hibernate
Error when running stored procedure in hibernate
Use substr function in Criteria