| Subject | Problem with AUTONOMOUS TRANSACTION |
|---|---|
| Author | Walter R. Ojeda Valiente |
| Post date | 2015-08-08T02:51:57Z |
Hello everybody
Do you know why this simple trigger "hang-up" the database?
CREATE TRIGGER TRANSACCION_INICIA
ACTIVE ON TRANSACTION START
POSITION 0
AS
BEGIN
IN AUTONOMOUS TRANSACTION DO BEGIN
END
END;
Always when I put "IN AUTONOMOUS TRANSACTION" the database crash. Without those words everything works fine.
It is not possible to use autonomous transactions inside a database trigger?
The same problem happens with SuperServer and Classic.
Windows 7, 32 bits
Firebird 2.5.4
Greetings.
Walter.