日期:2014-05-16 浏览次数:20914 次
function fun_sys_getparmrole(userid varchar2) return cur_type is
cur_type_tp cur_type;
counts number:=-1;
ls_userid varchar2(50);
lp_str varchar2(100);
lc_str varchar2(500);
ls_temp1 varchar2(2000);
ls_temp2 varchar2(2000);
ls_temp3 varchar2(2000);
begin
lp_str:='drop table self_temp_back';
execute immediate lp_str;
lc_str:='create global temporary table self_temp_back(fconfigid varchar2(50), fparname varchar2(500), fparvalue varchar2(500)) on commit preserve rows';
execute immediate lc_str;
open cur_type_tp for select fconfigid, fparname, fparvalue from self_temp_back;
return(cur_type_tp);
end fun_sys_getparmrole;