--1. 创建一个包
create or replace package ch_package is
--过程或函数声明
procedure my_pro(chName varchar2);
function my_fun(chName varchar2) return number;
end;
2. 创建包体
--2. 创建包体
create or replace package body ch_package is
--过程
procedure my_pro(chName varchar2) is
v_sal emp.sal%type;
begin
select sal into v_sal from emp where ename=chName;
commit;
dbms_output.put_line(chName||'的薪水是：'||v_sal);
end;
function my_fun(chName varchar2) return number is
v_sal emp.sal%type;
begin
select sal into v_sal from emp where ename=chName;
commit;
return v_sal;
end;
