procedure p_get_ename_sal_dept_of_emp

create or replace procedure p_get_ename_sal_dept_of_emp
(pv_emp_no in emp_100.empno%type)
as
lv_ename emp_100.ename%type;
lv_sal emp_100.salary%type;
lv_dept emp_100.deptno%type;
begin
  select ename,salary,deptno into lv_ename,lv_sal,lv_dept from emp_100 where empno=pv_emp_no;
  dbms_output.put_line('the emp no'||' '||pv_emp_no||' '||'are..');
    dbms_output.put_line('the name of the  emp'||' '||lv_ename);
    dbms_output.put_line('the emp dept'||' '||lv_dept);
end p_get_ename_sal_dept_of_emp;
  -- select * from emp_100;