oracle事务自治
函数加上如下语句表示事务自治
?
? PRAGMA AUTONOMOUS_TRANSACTION;
?
?
?
例：
?
create or replace function func_made_applycode(schoolcode in varchar2,spe_level in integer) return varchar2 is Result varchar2(20); /*生成报名号*/ v_yearno year_semester.year_value%type; v_semesterno year_semester.semester_value%type; v_liushui number; PRAGMA AUTONOMOUS_TRANSACTION;begin select a.year_value,a.semester_value into v_yearno,v_semesterno from year_semester a where a.isused =1 and rownum = 1; select nvl(max(to_number(substr(a.apply_code,9,5))),0) into v_liushui from apply_info a where substr(a.apply_code,1,4) = v_yearno and substr(a.apply_code,5,1) = v_semesterno and substr(a.apply_code,6,2)= schoolcode; v_liushui := v_liushui+1; Result := v_yearno||v_semesterno||schoolcode||case spe_level when 103001 then 1 when 103002 then 7 when 103003 then 4 end||lpad(v_liushui,5,0); return(Result);end func_made_applycode;
?
