Rollback and Commit
From: anders_tung_at_hotmail.com <(anders_tung_at_hotmail.com)>
Date: 7 Jun 2004 08:00:13 -0700
Message-ID: <da2e9ee1.0406070700.40d26356_at_posting.google.com>
Hi,
end function_one();
end function_two();
end function_three(); Received on Mon Jun 07 2004 - 17:00:13 CEST
Date: 7 Jun 2004 08:00:13 -0700
Message-ID: <da2e9ee1.0406070700.40d26356_at_posting.google.com>
Hi,
return number is
ret_one number := 0;
begin
update dummy1 set dummy_col ='dummy';
return ret_one;
EXCEPTION
WHEN OTHERS
THEN ret_one:=1; RETURN ret_one;
end function_one();
function_two()
return number is
ret_two number := 0;
begin
delete from dummy2 where dummy_col ='dummy';
return ret_two;
EXCEPTION
WHEN OTHERS
THEN ret_two:=1; RETURN ret_two;
end function_two();
function_three()
return number is
ret_three number := 0;
begin
insert into dummy3 (dummy_col) values ('dummy');
return ret_three;
EXCEPTION
WHEN OTHERS
THEN ret_three:=1; RETURN ret_three;
end function_three(); Received on Mon Jun 07 2004 - 17:00:13 CEST