Subject | COMMITS NEEDED INSIDE STPROCS? |
---|---|
Author | csswa |
Post date | 2002-04-12T07:24:04Z |
I noticed that commits aren't used inside stprocs -- well, not in the
doc examples. Is there any harm in including hard commits inside
stprocs or will this cause problems, e.g.
create procedure (etc.)
begin
insert into ...;
commit;
update foobar set ...;
commit;
end
doc examples. Is there any harm in including hard commits inside
stprocs or will this cause problems, e.g.
create procedure (etc.)
begin
insert into ...;
commit;
update foobar set ...;
commit;
end