--首先包声明 存储过程名称后面如果没有参数就不要括号
create or replace package test_packge is
procedure test_pro(in_id in varchar2, out_result out varchar2);
end test_packge;
--包体
create or replace package body test_pck is procedure t_pro as
begin
insert into t_user_temp(user_id,user_no) values('1111', '测试');
end;
end test_pck;
create or replace package test_packge is
procedure test_pro(in_id in varchar2, out_result out varchar2);
end test_packge;
--包体
create or replace package body test_pck is procedure t_pro as
begin
insert into t_user_temp(user_id,user_no) values('1111', '测试');
end;
end test_pck;