create or replace procedure alta_emp
    (v_emp_no in emp.empno%TYPE,
    v_emp_name in emp.ename%TYPE,
    v_emp_job in emp.job%TYPE,
    v_mgr_no in emp.mgr%type,
    v_emp_sal emp.sal%type)
is
    v_emp_hiredate emp.hiredate%type;
    v_emp_comm emp.comm%type;
    v_emp_deptno emp.deptno%type;
begin
    v_emp_hiredate:=sysdate;
    v_emp_comm:=0;
    select deptno into v_emp_depno from emp where empno = v_mgr_no;
    insert into ..