1 Reply Latest reply on Feb 11, 2014 7:29 PM by Johan Louwers

    parameter procedur


      hi  i have created a  PROCEDURE Get_emp_names (Dept_num IN NUMBER) IS

      Emp_name       VARCHAR2(10);

         CURSOR         c1 (Depno NUMBER) IS

                           SELECT Ename FROM Emp_tab

                              WHERE deptno = Depno;

      it is sucssfully created  now  how to call or  execute this procedure i need help