value « Oracle « JPA Q&A

1. Getting the return value of a PL/SQL function via Hibernate    stackoverflow.com

I have a PL/SQL function in an Oracle database that I can't change. This function takes a parameter which identifies an entity, creates a copy of that entity and then returns ...

2. How to call a custom Oracle function returning a value from JPA    stackoverflow.com

I have a custom function in oracle returning a number after deleting records. I could get a value in sql_plus such as

call my_function(4) into :out_number;

3. Return value of a oracle stored function    forum.hibernate.org

Hi, I have the same problem. I call a oracle stored function with tag {? = call deletenode (?)} The documentation says...Hibernate always registers the first statement parameter as a numeric output parameter for the CUD operations... but when i call the delete method.... TestHibernateUtil.getSessionFactory().getCurrentSession().beginTransaction(); ...... TestHibernateUtil.getSessionFactory().getCurrentSession().delete(object); TestHibernateUtil.getSessionFactory().getCurrentSession().getTransaction().commit(); .... I receive the following error: Hibernate: {? = call fdeletenode ...