Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Session session = HibernateUtil.getSessionFactory().openSession();
- Query query = session.getNamedQuery("EMPLOYEE.PRC_HB_EMP_SP1");
- query.setParameter("IN_EMPID", empId);
- List<Employee> empList = query.list();
- System.out.println(empList);
- @Entity
- @Table(name = "EMPLOYEE")
- //@org.hibernate.annotations.NamedNativeQuery(name = "EMPLOYEE.PRC_HB_EMP_SP1", query = "call PRC_HB_EMP_SP1(?,:IN_EMPID)", callable = true, resultClass = Employee.class)
- @org.hibernate.annotations.NamedNativeQuery(name = "EMPLOYEE.PRC_HB_EMP_SP1", query = "call PRC_HB_EMP_SP1(?,:IN_EMPID)", callable = true, resultClass = Employee.class)
- public class Employee implements Serializable {....}
- create or replace PROCEDURE PRC_HB_EMP_SP1
- (
- Out_value OUT SYS_REFCURSOR,
- IN_EMPID NUMBER
- )
- AS
- BEGIN
- open Out_value for
- SELECT EMPID,EMPNAME
- FROM EMPLOYEE
- WHERE EMPID = IN_EMPID;
- END PRC_HB_EMP_SP1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement