[MonetDB-users] Transaction management in stored procedures

Hi all,

Does anyone knows how can I handle transactions in a stored procedure? In procedure definition on SQL Reference says that a procedure_statement may consists of transaction_statement etc. How transaction_statement implemented in a stored procedure? I tried (inside the BEGIN ... END block of stored procedure) the:

START TRANSACTION; sql statements COMMIT;

and:

sql statements COMMIT;

but both they do not work.

Thanks, Vassilis