Hello Homer,

> Is it possible to use transactions in a stored procedure? I've looked it up in Helen's book and done the Google thing, but I am not able to make it work.

Starting with Firebird 2.5, yes. For details, read the Release Notes:

http://www.firebirdsql.org/rlsnotes/Firebird-2.5.0-ReleaseNotes.pdf
(chapter Procedural SQL, sections Autonomous Transactions and New Extensions to EXECUTE STATEMENT)

-or-

http://www.firebirdsql.org/rlsnotesh/rlsnotes25.html#rnfb25-psql-auton
http://www.firebirdsql.org/rlsnotesh/rlsnotes25.html#rnfb25-psql-exctstmnt


Cheers,
Paul Vinkenoog