Hi,
I have a problem with NamedNativeQuery calling. I try to call an Oracle package procedure what has no return value and out parameter.
I wrote an Entity annotated class, what I added to my config, but when I try to use the query then I got an error:
"Named query not known. KarSet"
Here is the class definition:
Code:
package com.ath.db;
import java.io.Serializable;
import javax.persistence.Id;
import org.hibernate.annotations.Entity;
import org.hibernate.annotations.NamedNativeQuery;
@Entity
@NamedNativeQuery(name = "KarSet", query = "call flexutil.pkg_cl_util.set_kar_udf(?, ?)", callable = true, resultClass=AthKarSet.class)
public class AthKarSet implements Serializable
{
private static final long serialVersionUID = 512975560291089577L;
@Id
public long getCallId()
{
return 1L;
}
}
And the calling:
Code:
...
Query lQuery = lSess.getNamedQuery("KarSet");
lQuery.setParameter(0, lData.getAthLoanId());
lQuery.setParameter(1, lData.getAthKarAct());
...
The package header:
Code:
procedure set_kar_udf(p_hfe_id varchar2, p_value varchar2);
Do you have any idea, what is the problem?
Thank you!
Feri
Login
FAQ
Search