Advertisement
Guest User

Untitled

a guest
Feb 6th, 2016
64
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.95 KB | None | 0 0
  1. Session session = HibernateUtil.getSessionFactory().openSession();
  2. Query query = session.getNamedQuery("EMPLOYEE.PRC_HB_EMP_SP1");
  3. query.setParameter("IN_EMPID", empId);
  4.  
  5. List<Employee> empList = query.list();
  6. System.out.println(empList);
  7.  
  8. @Entity
  9. @Table(name = "EMPLOYEE")
  10. //@org.hibernate.annotations.NamedNativeQuery(name = "EMPLOYEE.PRC_HB_EMP_SP1", query = "call PRC_HB_EMP_SP1(?,:IN_EMPID)", callable = true, resultClass = Employee.class)
  11. @org.hibernate.annotations.NamedNativeQuery(name = "EMPLOYEE.PRC_HB_EMP_SP1", query = "call PRC_HB_EMP_SP1(?,:IN_EMPID)", callable = true, resultClass = Employee.class)
  12.  
  13. public class Employee implements Serializable {....}
  14.  
  15. create or replace PROCEDURE PRC_HB_EMP_SP1
  16. (
  17. Out_value OUT SYS_REFCURSOR,
  18. IN_EMPID NUMBER
  19. )
  20. AS
  21.  
  22. BEGIN
  23.  
  24. open Out_value for
  25. SELECT EMPID,EMPNAME
  26. FROM EMPLOYEE
  27. WHERE EMPID = IN_EMPID;
  28.  
  29. END PRC_HB_EMP_SP1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement