Hi,

I would be surprised if you could get this compiled ... Commit/rollback
isn't supported inside stored procedures - these always run in the
client transaction context.

So, no harm to be done :)

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com



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