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

    parameter procedur

    a2116479-ee5b-4ea9-8362-bd74caec9c72

      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