Subject | Transactions within a stored procedure |
---|---|
Author | Jonathan Hull |
Post date | 2004-03-01T23:52:15Z |
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
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