Invalid column name while calling store procedure

[pankaj semwal]

Hi List[],
I am calling store procedure as i am using oracle database .But i am getting the following exception:

Caused by: java.sql.SQLException: Invalid column name
	at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
	at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
	at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
	at oracle.jdbc.driver.OracleStatement.get_column_index(OracleStatement.java:6348)
	at oracle.jdbc.driver.OracleResultSetImpl.findColumn(OracleResultSetImpl.java:1557)
	at oracle.jdbc.driver.OracleResultSet.getString(OracleResultSet.java:1549)

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
:

CREATE OR REPLACE
PROCEDURE HMIA1.PROC_PARTCHECK(
    V_RETVAL1 OUT SYS_REFCURSOR ,
    V_PARTFROM VARCHAR2,
    V_PARTTO   VARCHAR2 )
AS
  partFrom VARCHAR2(12);
  partTo  VARCHAR2(12);
BEGIN
  partFrom:=NULL;
  partTo:=NULL;
  OPEN V_RETVAL1 FOR SELECT mpim_part_no_frm, mpim_part_no_to into partFrom, partTo  FROM rempim_tb WHERE V_PARTFROM BETWEEN mpim_part_no_frm AND mpim_part_no_to;
END;

and i am calling like this

  Query query = getSession().getNamedQuery("checkPart"); 		 
			  query.setParameter("partFrom",fromPart); 
			  query.setParameter("partTo",toPart);			  
 		    	  query.list();

Please tell me where i am wrong.

Thanks

[Wouter Oet]

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