PL/SQL out 类型存储操作

   out 类型存储操作
      create or procedure q_sal    
   (id in employees.employee_id%type,
     percent in number，
     name out employee.last_name%type)
   is
   begin
   select last_name into name from employees
   where employee_id=id;
   end q_sal;
   /
   调用put包调用out类型
   set serveroutput on
   declare 
     emp_name employees.last_name%type;
     emp_sal employees.salary%type'
    begin
    query_emp(171,emp_name,emp_sal);
    dbms_ouput.put_line('Name:'||emp_name);
    dbms_ouput.put_line('Sal:'||emp_sal);
    end;
    或者
    host变量使用：全局变量
    variable name varchar2(25)
    variable sal number
    exec quer_emp(171,:name,:sal)使用：调用
    print name sal