JSF and ADF Page Lifecycles
How to call Procedure function in UI page
Procedure call First we need to call procedure query in HR connection we have a column as procedures in that we have create GET_EMPLOYEES in that run this query. -------------------------- ------------------------------------------------ -------------------------------------------- create or replace PROCEDURE GET_EMPLOYEES ( EMPID IN NUMBER , FNAME OUT VARCHAR2 , LNAME OUT VARCHAR2 , EMAIL OUT VARCHAR2 , DEPTID OUT NUMBER , SALARY OUT NUMBER ) AS BEGIN select first_name,last_name,email,department_id,salary INTO FNAME,LNAME,EMAIL,DEPTID,SALARY from employees where employee_id=EMPID; dbms_output.put_line('Hello World 2022!'); dbms_output.put_line(FNAME); dbms_output.put_line(LNAME); dbms_output.put_line(EMAIL); dbms_output.put_line(DEPTID); dbms_output.put_line(SALARY); END GET_EMPLOYEES; ---------------- ------------------------...
Comments
Post a Comment