Nested Oracle Stored Procedures
572518Jan 8 2008 — edited Jan 8 2008I have below nested stored proc call ..
what happens if inner proc rolls back transaction , does outer proc also rollsback or it will continue its exection.
outerProc( ) as
begin
insert into table ...
innerProc()
commit;
end;
innerProc() as
begin
insert into table ..
commit;
exception when others then rollback;
end;