Subject Transactions within a stored procedure
Author Jonathan Hull
Hi,
Should it be possible to do a 'set transaction' within a stored
procedure in Firebird 1.5?

I am asking this as I get an error -104, token unknown on the 'SET'
command within my SP.

As an example of the failure :

create table test_set_txn (field1 varchar(100));

SET TERM ^ ;
create procedure sp_test_set_txn
as
begin
SET TRANSACTION t1 wait;
insert into test_set_txn (field1) values ('testing...');
commit t1;
when any do
begin
rollback t1;
end
end ^
SET TERM ; ^

Cheers,
Jono