오라클 stored procedure

create procedure pro2
as
  vs_emp_name employees.emp_name%TYPE;
  vs_dep_name departments.department_name%TYPE;
begin
  dbms_output.enable;
  select a.emp_name, b.department_name
  into vs_emp_name, vs_dep_name -- 컬럼의 값을 변수에 각각 저장
  from employees a, departments b
  where a.department_id=b.department_id
  and  a.employee_id=100;
 
  -- 출력.app에서는 결과값을 사용 못함.
  dbms_output.put_line(vs_emp_name || '-' || vs_dep_name);
end;

--set serveroutput on size 1000000; -- 출력기능 활성화
exec pro2;