|
[x]
Posted via EE Mobile
|
|
| Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again. |
|
|
|
|
Asked by ncsvietnam in Databases Miscellaneous, Oracle CRM, PL / SQL
Hi experts,
Please help me out this problem!?
I have a function calls other functions inside it's body, pls see it in the attached code.
My question is how to rollback fcn_B and func_C if fcn_D raise an exception?
Thanks!
1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
|
function A return varchar2 is
v_RET varchar2(100)
begin
v_RET := fcn_B('test'); -- insert a record to B table
v_RET := fcn_C('test'); -- insert a record to C
v_RET := fcn_D('all'); -- insert a record to D
return v_RET;
exception when others then rollback;
end;
|
20091021-EE-VQP-81 - Hierarchy / EE_QW_3_20080625
