New to hibernate & Java. I am trying to execute a stored procedure with no parameters that doesn't return any value.
hibernate.hbm.xml
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<!-- a bunch of class tags with mappings that work -->
<sql-query name="SP_DeleteOrphanObjectCondition" callable="true">
{ call DeleteOrphanObjectCondition() }
</sql-query>
</hibernate-mapping>

I also tried:
{ ? = call DeleteOrphanObjectCondition() }
with the same result.

I am running:
getHibernateSession().getNamedQuery("SP_DeleteOrphanObjectCondition").uniqueResult();

I get an error:
org.hibernate.MappingException: Named query not known: SP_DeleteOrphanObjectCondition
at org.hibernate.impl.AbstractSessionImpl.getNamedQuery(AbstractSessionImpl.java:93)
at org.hibernate.impl.SessionImpl.getNamedQuery(SessionImpl.java:1287)

Can someone help me with this? Greatly appreciated. Thanks.