17,086
社区成员
发帖
与我相关
我的任务
分享
--包头
create or replace package pkg_test is
function f_getsumareaname(in_area_id int, in_area_type int) return varchar2;
procedure p_test;
procedure p_main;
end pkg_test;
--包体
create or replace package body pkg_test is
function f_getsumareaname(in_area_id int, in_area_type int) return varchar2 is
v_sumareaname varchar2(100);
begin
begin
select t.area_name
into v_sumareaname
from t_area t
where t.area_type_id = in_area_type
and t.area_id = in_area_id;
exception
when others then
v_sumareaname := null;
end;
return v_sumareaname;
end f_getsumareaname;
procedure p_test is
begin
begin
execute immediate 'drop table T_OWEFEE';
exception
when others then
null;
end;
execute immediate 'create table t_owefee as select f_getsumareaname(a.area_id,2) as xj,f_getsumareaname(a.area_id,3) as zj,f_getsumareaname(a.area_id,5) as pq,f_getsumareaname(a.area_id,6) as sq,a.owefee from tmp_ffp_servacctarea a';
end p_test;
procedure p_main is
begin
p_test;
end;
begin
null;
end pkg_test;