title: java.sql.SQLException: ORA-06576: not a valid function or procedure name
body: <p>When <code>saveDepartment()</code> is invoked, I am getting exception mentioned in the title. After searching for solution for a while I came up with another similar post on stackoverflow which doesn't match the problem scenario I am facing.</p>
  
  <hr>
  
  <p>Dao class:</p>
  
  <pre><code>@Repository
  public class DepartmentDaoImpl implements DepartmentDao {
  
      @Autowired
      private SessionFactory sessionFactory;
  
      @Override
      @Transactional
      public void saveDepartment(Department department) {
          Session session = sessionFactory.getCurrentSession();
          session.save(department);
      }
  }
  </code></pre>
  
  <hr>
  
  <p>Bean configuration section for hibernate:</p>
  
  <pre><code> &lt;bean id="sessionFactory" class="org.springframework.orm.hibernate4.LocalSessionFactoryBean"&gt;
          &lt;property name="packagesToScan" value="net.therap.domain.tmp"/&gt;
          &lt;property name="dataSource" ref="dataSource" /&gt;
          &lt;property name="hibernateProperties"&gt;
              &lt;props&gt;
                  &lt;prop key="hibernate.dialect"&gt; org.hibernate.dialect.HSQLDialect&lt;/prop&gt;
                  &lt;prop key="hibernate.show_sql"&gt;true&lt;/prop&gt;
              &lt;/props&gt;
          &lt;/property&gt;
      &lt;/bean&gt;
  
      &lt;bean id="transactionManager"
            class="org.springframework.orm.hibernate4.HibernateTransactionManager"&gt;
          &lt;property name="sessionFactory" ref="sessionFactory" /&gt;
      &lt;/bean&gt;
  </code></pre>
  
  <p>Any suggestion or solution regarding the problem is appreciated.</p>